Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
Need help calculating the percentage of all project tasks and return a value in percentage
Hi, I am trying to add a project status percentage in my project dashboard. I have the list of tasks, % complete, and Task Status in the project sheet. I tried to use the sheet summary to get the % value of the tasks that are not marked "completed" but I am not able to. What is the correct formula to use in the sheet summary to come up with what % the project is at? I have attached the columns I am using. Thanks in advance.
Best Answer
-
I personally use a normal report. I use the "Group" tab to group by Status column and then the "Summary" tab to count the Status. After I save the report I just create a widget to display the data in a donut form (or whatever you prefer). This is how mine shows up!
Answers
-
I personally use a normal report. I use the "Group" tab to group by Status column and then the "Summary" tab to count the Status. After I save the report I just create a widget to display the data in a donut form (or whatever you prefer). This is how mine shows up!
-
That's a good idea too. Thanks Brittney!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.1K Get Help
- 448 Global Discussions
- 154 Industry Talk
- 503 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 80 Community Job Board
- 512 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- When I use a concatenate formula to combine a Date and Time to create an individual code, the Date appears in the default format 01/01/25 but the date in the Column it is referencing is formatted 2025…
- Hello, I'm trying to set up a formula which will calculate the difference between two dates to achieve a days overdue number for our orders. Current formula is: =IF(Status@row = "Delivered", NETWORKDA…
- Good morning. I have tried the 2 formula's that I found on the internet and copilot and neither are working for me. Can someone please help me figure out how to calculate the KM distance between the l…
