Sheet Summary Formulas

tiffany130

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?

SteyJ

Completed project tasks

=COUNTIF(Status:Status, "Complete")

Tasks in progress

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

Not started

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

SteyJ

Completed project tasks

=COUNTIF(Status:Status, "Complete")

Tasks in progress

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

Not started

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

tiffany130

One more if you can...if I want to have just a count of all Tasks and I have a column titled "Task Name" with 17 tasks under it...is the formula a SUM?

SteyJ

https://community.smartsheet.com/discussion/comment/410235#Comment_410235

correct!

=SUM([Task Name]:[Task Name])