Help with ANCESTORS function

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!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!