How do I do a formula

Chad Rasmussen

Hi I am new to Smartsheets and to formulas. I am trying to tell she sheet if the cell says OOS, I want it to count each cell on the sheet and give me the total in another cell. What formula can I use?

Becky Wilson

Sounds like you might want to use countif:

In the cell you want to use to display the answer:

=CountIf([Column One]:[Column One],"OOS")

This assumes that OOS is cells associated with only in one column

Becky Wilson

Sounds like you might want to use countif:

In the cell you want to use to display the answer:

=CountIf([Column One]:[Column One],"OOS")

This assumes that OOS is cells associated with only in one column

Chad Rasmussen

Thanks Becky that worked