Calculate % Complete at Child Level AND Parent Level in one formula

I want to use the following formula as a column formula but have the % complete roll up to the parent level. See formula and snapshot as it appears now. I want Q3 and July Promotions fields to reflect a percentage completion based on the children rows. I can't seem to make it work!

% Complete formula:

=IF(Status@row = "Done πŸ”΅", "100%", IF(Status@row = "Approval Pending 🟑", "50%", IF(Status@row = "Scheduled πŸ“…", "75%", "0%")))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!