Parent function to auto-populate cells


Hi everyone,

Wondering if someone could help me with a formula to auto-label cells. I'm creating a project tracker for my team on Smartsheet and have automation set up for approval process, and also so completed tasks are moved to a new sheet. The problem is, on both instances, the row itself might not contain all information if it's a child row to a parent campaign or main task. So to help with this issue, I'm creating two new columns for campaigns and projects/main task. I want these two new columns to auto-populate to avoid manual work, and used the PARENT formula to do it. However, if something has two indentations, how can I get the parent of the parent?

Screenshot here for reference.

Thanks in advance,


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!