Nested Formulla

Options

Best Answer

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi @Vinton Douglas,

    With the Month column with Month & Year in it, then you can use the following with a column changed to percentage:

    =(COUNTIFS([Criteria Established 2]:[Criteria Established 2], "Met", Month:Month, "August 2022")) / COUNTIF(Month:Month, "August 2022")

    For the other criteria just change the "Met" for the relevant criteria.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!