I’m trying out Coda and very happy with it.
I have two questions regarding formulas and hope to get some answers here.
If you see “Summary > Monthly Summary per Category”,
I grouped the table by Year Month and Category.
I was able to display a chart with Year Month + Category + Sum(AMOUNT).
And now I want to display “sum(amount)/budget” instead of sum(amount).
So first, I added a column named “Budget” there, but my formula doesn’t work.
It’s basically getting a row from “Budget” table matching Category, and why is the result an empty array?
This is minor compared to the first one.
If you see “Summary > Summary of this month”, on “Budget” columns, there’re red triangles and the tooltip says it’s not a valid row reference. What does it mean?
Thanks for reading it