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 Cells by Color
JackPMO
✭
how do I count cells of a specif color in a row? Countif does not seem to do this as it does in Excel.
Comments
-
Hello,
If you're referring to a symbol column—RYG ball, for example—you can use the text label for the symbol in a COUNTIF function, e.g.
=COUNTIF(Status:Status, "Red")
The text label for a symbol appears in the cell dropdown next to the symbol. More information on symbol columns can be found in the help article on Column Types.
You can find more info on the COUNTIF function here: https://help.smartsheet.com/function/countif
Otherwise, there isn't a way to count based on cell background or font colors.
This discussion has been closed.
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives