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

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

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
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!