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%")))