Level Formula Not Working



I have been using the same level formula for a while, but for some reason on a newly created sheet, my formula isn't working, and I can't figure out why. Here is a screenshot of the relevant columns:

The formula I've entered is:

=(IF(COUNT(CHILDREN([Study Protocol]@row)) > 0, COUNT(ANCESTORS([Study Protocol]@row)) + 1))

I've also tried:

=IF(COUNT(CHILDREN([Study Protocol]@row)) > 0, COUNT(ANCESTORS()) + 1)

Neither is resulting in a number being entered into the "Level" column for any of the rows, parent or child. Can anyone determine what is incorrect in my formula?


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!