Hello,
I am trying to link my daily habit log into my summary habit table.
But I am unable to do because there is no direct formula to do so.
I Dont want to change the format of my summary table.
How can I do this?
Hello,
I am trying to link my daily habit log into my summary habit table.
But I am unable to do because there is no direct formula to do so.
I Dont want to change the format of my summary table.
How can I do this?
I am on my phone now, so will be tough idea, cannot check.
But try something along the line of the following formula in column progress:
In a switchIf:
for each of the Daily habits, build a filter that selects the rows falling from Startdate to end date. Then add .sum() or .Count().
Hope that gets you going.
P
Thanks. I Want to make it like whenever i add new habit, and add same name column, it automatic finds that column and gives me the progress. how to do this?
A long as you stick to the current design that you have, you are not going to be able to do that.
Coda is not a spreadsheet, and as log as one insists on treating it like a spreadsheet, so long are you going to struggle to get simple things done.
I know that coda works differently then excel, what I want is, daily habit tracking by Buttons in my other page ( which i am going to make mobile friendly) and linking these habit progress to my goals.
This is what I came in my mind because I used spreadsheet before, Is there any another way or idea to do that?
Learned how coda works and make different view. Actually I was worried about that can Coda handle 3000 rows without lagging on phone app and thats why not using the right way but I get assured that will not and now I made my habit tracker. Also, I can use Button in which It Modifies the row so leading to inserting less rows. Thanks.
HI @D.K_Zala
I am glad that you were able to get satisfy your requirements.
I have done an example here for other people with the same question: