Formula -weighted for specific criteria

JennS_ ✭✭✭
edited 12/09/19 in Formulas and Functions

I have a complicated request. I want to create a formula that will provide a % when a row is designated as a "critical path" item. See screenshot. As a box is checked in the column for each cabin name, I want to get the % to update for those critical checked boxes.

Is there a way to do this? I already have a formula that takes into account the entire sheet, all checkboxes and the formula of percent complete for all boxes checked. But want to separately tally the critical ones too.

Thank you.

Critical path.JPG


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!