Sheet Summary equation

I am trying to create an equation in a Sheet Summary field that counts all items that have not passed approval. This would involve counting all items in the Status field that are Not Started, In Progress, Failed, or On Hold. I have tried multiple variations of the CountIf and CountIfs statements, but everything is unparseable. Help please!

Find more posts tagged with

Formulas

Sheet Summary

Accepted answers

cnikkih

So right after I posted this, I finally found my answer. Sorry about that! I just didn't search long enough.

In case it helps anyone else, my answer was this:

=COUNTIF(Status:Status, "Not Started") + COUNTIF(Status:Status, "In Progress") + COUNTIF(Status:Status, "Failed")

All comments

Andrée Starå

Hi @cnikkih

I hope you're well and safe!

Can you share the formula you're trying?

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

cnikkih

So right after I posted this, I finally found my answer. Sorry about that! I just didn't search long enough.

In case it helps anyone else, my answer was this:

=COUNTIF(Status:Status, "Not Started") + COUNTIF(Status:Status, "In Progress") + COUNTIF(Status:Status, "Failed")

Andrée Starå

@cnikkih

Excellent!

Glad you solved it!

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.