Count to show the High Priority Items
Kris Peeters
✭✭✭✭
I would like to add a formula that counts the number of 1 - High, 2 - Med, 3 - Low in each row.
Best Answer
-
you should be able to use =Countifs([Al Javor]@row:[Lisa Young]@row,"1 - High")
Answers
-
@Kris Peeters Use the count if formula as: =countif(javor:javor, @cell="1- High") + countif(zarda:zarda, @cell="1- High") +... For the medium and low just change the @cell =
Hope it helps!
-
Here is what I have and it's not working.
=COUNTIF([Al Javoroski]@row:[Lisa Young]@row]="1 - High")
-
you should be able to use =Countifs([Al Javor]@row:[Lisa Young]@row,"1 - High")
-
Yes, that worked thank you!
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!