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)
Best Answer
-
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)
Answers
-
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)
-
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
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!