Hello, I am trying to move our P&L sheet from Google into Coda but struggling with how to make the formulas work for me. In the screenshot below, I am trying to sum the values from the [individual] table in the matching column within the [calc] table.
For reference, here is my current Coda setup, and under that is the Google Sheet I am trying to move into Coda. The bolded values are formulas.
Coda formulas are still new to me and I’m struggling to find a way to correctly reference the rows and columns in the [individual] table so that the sum will display. I have my [calc] table laid out this way because some of the columns down the line will have formulas other than a sum (division, etc) and I needed the formulas to run down the column so that they line up with the correct month.
If I am doing this a totally backward way and there is a better solution, I would be so happy for any help you have to offer!