How to have Column 2 numerical values calculate from Column 1 numerical values

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?

Screen Shot 2021-08-09 at 9.55.40 AM

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:


where each column would get its own formula where you could increment 200 to 300, etc