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

edited 12/09/19 in Archived 2017 Posts

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.

This discussion has been closed.