Percentage complete with multiple criteria for children

Namaste03 ✭✭
edited 08/17/23 in Formulas and Functions

I have child rows with a drop-down that have the following options in the "Status" column: Complete, Not Started, In Progress, Blocked, N/A.

In the "% Complete" column, I currently have a working formula that updates the percentage complete if a row is marked as "Complete". I need the formula to also update the "% Complete" column if "N/A" is selected. I need to have N/A as an option for our records.

I have tried working with "COUNTIFS" and "OR" but I cannot seem to get my function working. Any help is greatly appreciated.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!