Countif yellow or red status symbol

cfischer
✭
Hi Smartsheets community,
Does anybody know how to count how many cells have one of two status symbols colors (e.g., either yellow or red)?
My current formula is =countif(or(range:range "yellow", range:range "red")).
Any help would be much appreciated!
-cfischer
Comments
-
Hi cfischer,
I don't know if there's a more elegant way to do this, but you could use the following formula:
=SUM(COUNTIF(range:range; "yellow"); COUNTIF(range:range; "red"))
Greetings
PS: Maybe you have to exchange all semicolons ; with commas , ... Since I use german language settings, this may not work for you.
-
try count(collect())
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 153 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives