Ancestor/Parent Formula Help

KMeyer ✭✭✭
edited 05/17/22 in Formulas and Functions

Hi, I'm needing help with a parent formula that would populate the Category column with the parent Task Name (where Hierarchy = 0). Here's a snapshot of an example, and basically when Hierarchy is larger than 0 the Category should populate with "E. Facilities, Equipment, & Assets"


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!