Nested Formulla


Best Answer

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

    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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!