Sheet Summary Formulas



This is a very basic question but I can't find a video or list of formulas to help, and I'm not great with remembering formatting that is needed for formulas. I'm playing around with how to build a Dashboard for a Sheet by using Sheet Summary. But I can't get these formulas right...

I'm trying to use the STATUS column, and build a Dashboard that will show how many tasks are Complete, In Progress, and Not Started. Can someone tell me what the formula should be?

Best Answer

  • SteyJ
    SteyJ ✭✭✭✭✭✭
    edited 12/18/23 Answer ✓

    Completed project tasks

    =COUNTIF(Status:Status, "Complete")

    Tasks in progress

    =COUNTIF(Status:Status, "In Progress")

    Not started

    =COUNTIF(Status:Status, "Not Started")


    Jacob Stey


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!