Is there a way to calculate a percentage (yes's/total) by unit, per month?

Options

The user is utilizing smartsheet to collect data on handwashing. They want to be able to calculate how many yeses to the total amount of audits in percent form. They want it grouped by units in the hospital and by month.

Best Answer

  • Heather Duff
    Heather Duff ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi @Chloe Wiley ,

    Here's my way of doing this, although someone else may be able to find a shorter formula:

    =COUNTIFS(Unit:Unit, UnitRef@row, Handwashing:Handwashing, 1) / COUNTIF(Unit:Unit, UnitRef@row)

    Here's my setup for reference to the column names:

    Hope this helps. Let me know if you have any questions.



    Best,

    Heather

Answers

  • Heather Duff
    Heather Duff ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi @Chloe Wiley ,

    Here's my way of doing this, although someone else may be able to find a shorter formula:

    =COUNTIFS(Unit:Unit, UnitRef@row, Handwashing:Handwashing, 1) / COUNTIF(Unit:Unit, UnitRef@row)

    Here's my setup for reference to the column names:

    Hope this helps. Let me know if you have any questions.



    Best,

    Heather

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!