How to Link Rows to Colums

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?

1 Like

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

1 Like

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?

1 Like

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.

1 Like

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?

1 Like

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.

2 Likes

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:

2 Likes