Sheet Summary Formulas

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?

Find more posts tagged with

Accepted answers

SteyJ

Completed project tasks

=COUNTIF(Status:Status, "Complete")

Tasks in progress

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

Not started

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

All comments

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])

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.