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.


2020-06-02 18_41_57-(2) [CLIENT] Internal PM Tracker - TEMPLATE - Smartsheet.com.png

Thanks in advance,

Natasha

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!