Count of different fields having a value of 5
Options
System
Employee Admin
This discussion was created from comments split from: COUNTIFS with OR.
Answers
-
Hi Community,
I have a different use case of COUNTIFS and OR and hoping some smart SS guru can help.
I life to get a count of different fields having a value of 5. COUNTIFs automatically assumes "AND" so I like to use "OR". I've searched the community articles but with no avail.
=COUNTIFS([PM/PM]@row, 5, [PM/SSB8]@row, 5, [PM SSB9]@row, 5, [PM - Change Mgmt]@row, 5, [PM - Agile]@row, 5)
Answer s/b 1
Thank you in advance.
-
Are you trying to get a count of how many each of those cells have 5?
If yes then:
=COUNTIFS([PM/PM]@row:[PM- Agile]@row, @cell=5)
If you wanted to return a check box (saying that at least 1 of those have 5), then:
=IF(COUNTIFS([PM/PM]@row:[PM- Agile]@row, @cell=5)>0,1,0)
-
Thank you Liebel
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!