How do I do a formula

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?

Best Answer

  • Becky Wilson
    Becky Wilson ✭✭✭✭✭
    Answer ✓

    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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!