How to count the status column?

@Khanambano try these. Believe it or not, the actual value of the cell is the color name, the circle symbol is just an overlay built into the column type.

=COUNTIF(Status:Status, "Green")

=COUNTIF(Status:Status, "Gray")

Ok no idea what's happening here:  (Status: [Column8]14Status, "Green"))

But since you're doing this from a remote sheet...

Once you start typing =COUNTIF( you'll see Smartsheet's popup helper screen. Click on Reference Another Sheet, and select the sheet where your status column is. Click on the column header for the Status column to select the entire column, and click OK. Smartsheet adds the range into the formula:

=COUNTIF({OACM Fire Jobs Tracker Range#}

Next, all you have to do is add a comma and the value you want to count:

=COUNTIF({OACM Fire Jobs Tracker Range#}, "Green")

That's it.

@Khanambano

You are sure you've selected the entire Status column for the {OACM Fire Jobs Tracker Range 7} range?

It's odd that you get a blank cell as a result. You should get a 0 if it's just not finding the Gray cells.

Can you add a temporary column to OACM Fire Jobs Tracker sheet, and use =COUNTIF(Status:Status, "Gray") to make sure it works? That may tell us if it's an issue with the range.

Another thing to check - click on a cell in the Status column, and then click the drop down button, and make sure that Gray is spelled that way and not "Grey" with an "e"; I don't know if this might change with regional settings or not.