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

Chloe Wiley

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.

Heather Duff

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

Heather Duff

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