Formula to Reference Cell in Column Using @row


I'd like to be able to have a column formula where a cell is the same value as the next direct cell in another column. For instance, I'd like the cell on my third row under column "Successor Responsible" to equal the cell on my fourth row under column "Task Responsible".

Of course, the simplest way to do this is to have the formula "=[Task Responsible]3" but since I need to convert to column formula this is not currently an option.

Any help would be greatly appreciated thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!