I would like to create a spreadsheet where i can track my habits. There will be following structure in spreadsheet.
1) Number: Numbering of habits
2) Habits: Name of Habits
3) Steak: Longest continued series of 'x' in cells
4) Max: Maximum steak i have achieved in past
i need formula to calculate steak and max. I have got this idea from medium.com/@hcokim/tracking-habits-with-google-sheets-3f769871da77
It is google spreadsheet but i cannot be always online, so i would like to create offline ms excel version. I will share once i complete. Thanks.
1) Number: Numbering of habits
2) Habits: Name of Habits
3) Steak: Longest continued series of 'x' in cells
4) Max: Maximum steak i have achieved in past
i need formula to calculate steak and max. I have got this idea from medium.com/@hcokim/tracking-habits-with-google-sheets-3f769871da77
It is google spreadsheet but i cannot be always online, so i would like to create offline ms excel version. I will share once i complete. Thanks.
Attachments
Last edited: