CountIFS with two conditions
In a smartsheet formula I am trying to count the number of rows for a column "Hierarchy" equal to 0 with the condition that Health column is equal to red. I wrote the formula like this but it isn't working: =COUNTIFS(Health:Health,"Red",Hierarchy:Hierarchy,0). What am I doing wrong?
Answers
-
@Carrie Tedesco Missing the quotes around the 0. :)
=COUNTIFS(Health:Health,"Red",Hierarchy:Hierarchy,"0")
If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.
Always happy to work through questions or concerns!
-
@Colleen Patterson thank you - I had tried that too but still results in "Unparseable". Any other thoughts?
-
@Carrie Tortorella I tested your formula in the sheet summary and it works fine. Is yours within the sheet?
-
@Carrie Tortorella to confirm, these are columns in the same sheet where you are writing your formula?
If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.
Always happy to work through questions or concerns!
-
@Colleen Patterson @Razetto Yes both columns are in the same sheet, but I'm putting the formula in a Summary field.
-
@Carrie Tortorella Not sure why it wouldn't work unless, maybe, the problem is the type of columns being used. I tested out with the health as a symbol column, hierarchy column and count field in summary sheet are both text.
-
Thank you both! I'll keep working on it.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 434 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 506 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- New program proposals are submitted via a form and collected on Sheet 1. When approved by a team leader, the row is copied to Sheet 2. I want to capture the date the copied occurred, which I thought w…
- I need to update a value in a new column. How would I look at a date column that shows dates between 01/01/2025 to 03/31/2025 and place the value of Q1_2025 into another cell?
- Hi, I'm looking to write a formula using references to a rate sheet (screenshot attached with sensitive information redacted). We have several types of rates here, and also ones that are per word, whi…