Sheet Summary Formulas

Options

Hello,

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 ✓
    Options

    Completed project tasks

    =COUNTIF(Status:Status, "Complete")
    

    Tasks in progress

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

    Not started

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


    Sincerely,

    Jacob Stey

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!