Formula to Count Across Rows



Checking to see if there is a way to count across rows rather than down columns. I would like to be able to identify how many times over the year the report was either sent on time, late, or not at all.

Screenshot provided for reference.

Thank you!


  • Michael Culley
    Michael Culley ✭✭✭✭✭

    Yea you can count across rows. You can do something like:

    =countif([Jan '22 Medicaid]1:[Oct 22' Medicaid]8,"Not Received")

    You can click on the starting cell and drag it to the ending cell to get the table range for the formula.

    Hope this helps.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!