Row number calculations as part of a formula

TR ✭✭
edited 12/09/19 in Formulas and Functions

Hi there,

I'm trying to replace the value of a row number in a formula. I have created a rowID column so each row has a row number in that column.

I would like to make calculations from that to replace the row number part of a cell reference with calculated value

i.e. =Status123

i want to be =Status(row#+Y)

How do I achieve this?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!