Parent Rows: formula to automate identification of parent row

Wendy Young
Wendy Young ✭✭
edited 06/11/20 in Formulas and Functions

I'm trying to use one of this formula to automate identification of parent rows:

=IF(COUNT(ANCESTORS([Task Name]1)) < COUNT(ANCESTORS([Task Name]2)), COUNT(ANCESTORS([Task Name]1)))

However, it's telling me that it is #UNPARSEABLE. What am I doing wrong?

Please help! Thank you!

Best Answer

«1

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!