Calculate percentage of cells complying to one criteria


I need to calculate the percentage of cells within a certain time frame that comply to a certain criteria.

More specifically, I need to calculate the % of complaints closed in the past 28 days (Date of closure = TODAY -28) that have a complaint investigation duration of less than 15 days.

Please find an example of the sheet I need to use for the calculation.

Help would be highly appreciated.



Best Answer

  • Sing C
    Sing C ✭✭✭✭✭✭
    Answer ✓

    Hi @Margherita Falavigna,

    I hope you are well. You could capture the % in a Sheet Summary Field, using the following formula:

    =COUNTIF([Date of Closure]:[Date of Closure], >TODAY(-28)) / COUNT([Date of Closure]:[Date of Closure])

    Remember to set the formatting of the Sheet Summary Field to 'Percentage'.

    Let me know if this will work for you.

    I hope this helps.

    Have a wonderful day!



    Sing Chen

    Process Architect, Ceridian



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!