Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
count decision formula
Hi all
I have a sheet that using the decision symbols, can anyone help me with the formula that counts the number of Yes, No, Hold. I would be happy if there was a way of just counting the number of the green yes
Many thanks
Comments
-
If you double click on the cell containing any symbol you will be able to see the text that occupies that cell and is replaced by the symbol. In the case of the DECISION symbols, you will want to use the words, "Yes" for green, "Hold" for yellow, and "No" for red.
Your countif statement for Green would look something like this: =Countif(Seen:Seen, "Yes")
To count Holds, simply replace "Yes" with "Hold", and to count No's - replace "Yes" with "No".
If you are wanting to count a different column than the seen column then you can replace it with the column name. If the range you are counting contains whitespace or ends in a number you will want to surround your column name in brackets. =Countif([Column Name]:[Column Name], "Yes")
-
Mike your a legend!!!!!
-
Thank you, you're too kind!
I am Glad I could help.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives