How to convert to @row functionality

Options
Jeff Dunning
Jeff Dunning ✭✭
edited 10/02/20 in Formulas and Functions

I cannot seem to reference the next row down if I convert row numbers to @row

from this:

=IF(COUNT(ANCESTORS([Task Name]3)) < COUNT(ANCESTORS([Task Name]4)), COUNT(ANCESTORS([Task Name]3)))

to this:

=IF(COUNT(ANCESTORS([Task Name]@row)) < COUNT(ANCESTORS([Task Name]4)), COUNT(ANCESTORS([Task Name]@row))) what do I do for [Task Name]4?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!