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")
Smartsheet Community Champion and Ambassador
If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.
-
@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?
Smartsheet Community Champion and Ambassador
If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.
-
@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
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!