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.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 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!