What am I doing wrong in this sheet summary?

I am trying to do a sheet summary formula to get the percent of tasked closed assuming Project Name is "RPA Project"

Please see formula:

=IF([Project Name]:[Project Name] = "RPA Project", (Closed# / [Count of Status]#), "")

The Closed # and Count of Status are also sheet summaries Below are their formulas:

=COUNTIF(Status:Status, "Closed")

=COUNT(Status:Status)

Find more posts tagged with

Countif

IF(

Accepted answers

Chance Marshall

AI helped me figure this out but I don't know how to delete the question

=COUNTIFS([Project Name]:[Project Name], "RPA Project", Status:Status, "Closed") / COUNT(Status:Status)

All comments

Chance Marshall

AI helped me figure this out but I don't know how to delete the question

=COUNTIFS([Project Name]:[Project Name], "RPA Project", Status:Status, "Closed") / COUNT(Status:Status)

Georgie

Hey @Chance Marshall,

I'm glad you got this resolved! Thank you for posting your solution - this will help other members!

For future reference, to delete a post, you can click the Flag icon at the bottom of the post and select Report, then select the Delete Post option and add a note as to why you want to delete it, and we can action it on the backend.

Cheers,

Georgie

bilism_kaley

Try this formula instead:

=COUNTIFS([Project Name]:[Project Name], "RPA Project", Status:Status, "Closed") / COUNTIFS([Project Name]:[Project Name], "RPA Project")

This way, it’ll count tasks for "RPA Project" correctly and give the right result.

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.