Help with ANCESTORS function

SallyJ
SallyJ ✭✭✭

I would like to use the ANCESTORS function to pull all ancestor information into a row, but I'm getting an error message. Please see screenshots below. Does anyone know what I'm doing wrong?

If this were working ideally, it would return the value: "Editorial Review ER1."

Thanks!

Screenshot 2024-09-12 at 2.00.21β€―PM.png Screenshot 2024-09-12 at 2.00.12β€―PM.png

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!