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.
Summary Report for multiple fields on one sheet
I need to create a Summary Report for multiple fields on one sheet. I am successful in getting the COUNTIF statement to work on one of the columns, but when I add fields for a different column, the count is not rendering the correct results. I am using this formula for the Overall Health functions -
=COUNTIF([Overall Health]:[Overall Health], "Yellow")
Any assistance on what I am doing wrong is appreciated!
Best Answers
-
Are you able to double click on the column and change it to Symbols?
Leroy Noriega | Smartsheet SME | Independent Smartsheet Consultant
Core App, Project Management and System Administrator Certifiedπ
E: leroy.noriega@yahoo.com | Linkedin Profile
-
Great! I'm happy I was able to help!
Leroy Noriega | Smartsheet SME | Independent Smartsheet Consultant
Core App, Project Management and System Administrator Certifiedπ
E: leroy.noriega@yahoo.com | Linkedin Profile
Answers
-
What is the formula Inside the 'Overall Health' Column?
Leroy Noriega | Smartsheet SME | Independent Smartsheet Consultant
Core App, Project Management and System Administrator Certifiedπ
E: leroy.noriega@yahoo.com | Linkedin Profile
-
Hi - it is
=COUNTIF([Overall Health]:[Overall Health], "Yellow")
I have one for each of the 3 colors.
-
For the Status fields, this is the formula which is working correctly.
=COUNTIF(Status:Status, "In Progress")
-
What formula is inside this column?
Leroy Noriega | Smartsheet SME | Independent Smartsheet Consultant
Core App, Project Management and System Administrator Certifiedπ
E: leroy.noriega@yahoo.com | Linkedin Profile
-
no formula - it is pulling the status field in Jira. This whole sheet comes from a Jira | SS Connector
-
Are you able to double click to see what inside the cell? Normally in Smartsheet you get either the symbol or the text, in your sheet I see both. This might be what is causing the issue.
On my sheet I used
=COUNTIF(Health1:Health10, "Green")
And under my Health column I have them name "Green" and the column Type is Symbols.
Leroy Noriega | Smartsheet SME | Independent Smartsheet Consultant
Core App, Project Management and System Administrator Certifiedπ
E: leroy.noriega@yahoo.com | Linkedin Profile
-
Hmmm - I see what you are saying. When I double click in the cell, nothing comes up. And these are the dropdown fields.
-
Are you able to double click on the column and change it to Symbols?
Leroy Noriega | Smartsheet SME | Independent Smartsheet Consultant
Core App, Project Management and System Administrator Certifiedπ
E: leroy.noriega@yahoo.com | Linkedin Profile
-
I just changed it to symbols but the data is still coming in with the color and the text, so it is still not rendering the correct count unfortunately. Unless - do I need to change the COUNTIF structure? Sorry - this is my first time with the summary fields and I am not a coder.
-
Wait - I just manually changed the data in that column by manually selecting the symbol and it worked! Thank you so much!
-
Great! I'm happy I was able to help!
Leroy Noriega | Smartsheet SME | Independent Smartsheet Consultant
Core App, Project Management and System Administrator Certifiedπ
E: leroy.noriega@yahoo.com | Linkedin Profile
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 207 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!