Parent function to auto-populate cells
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,
Help Article Resources
Check out the Formula Handbook template!