Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
how do I count cells of a specif color in a row? Countif does not seem to do this as it does in Excel.
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.
