I don’t know the technical way to ask this question. But here is the goal:
If Column 1 = 207
Then column 2 should be = 307
Column 3 = 407
Column 4 = 507
Column 1 values are inputted manually, I want the rest of the Column values to calculate automatically.
Can the community help with what this column formula would be?
Hey @David_Self !
You should be able to do:
Column 1 + 100
You can’t do multi-column formulas so you’d have to write the formulas for the other columns. You can do either:
Column 1 + 200 or column 2 + 100 for the other columns.
This is so simple, I’m not sure I’ve felt more dumb. Thank you Coda community and @Scott_Collier-Weir for being there on the days that I’m this dumb.
Another thing it looks like you are doing is incrementing by 1, so you could do:
=sum(rowID(thisrow),200)
where each column would get its own formula where you could increment 200 to 300, etc