Count of different fields having a value of 5
System
Employee
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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!