Formula that counts the total of red dot symbols in my status column


Hi everyone, I have a project plan with several rows. There's a STATUS column in which traffic lights colours (gray, green, yellow and red) appear depending on the closeness of the task to its deadline.

In another sheet, I'd like to link a cell to the STATUS column and use a formula that counts how many red dots there are in the project plan. Does someone know a formula that works for that?

Best Answer

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭
    Answer ✓

    You will want to setup a cross sheet reference to be able to access the information from your source sheet. Your formula would then be something similar to:

    =COUNTIF({Status}, "Red")

    Where {Status} is your label for the reference to the source sheet.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!