simple COUNTIF Sheet Summery formula
need help with this simple formula for a sheet summary
=COUNTIF([IEP Status], "NEW (not signed)", "Active", "Active (Needs Att.)")
something is wrong with the formatting I want to count number rows that contain these specific drop down list values. I put the values in quotes but the parentheses from the drop down values are turning pink which I think means they are registering as part of the formula. do i need to remove the parentheses from my drop down values for this to work right?
thanks much!
Best Answer
-
Give this a shot:
=COUNTIF([IEP Status]:[IEP Status], OR(@cell = "NEW (not signed)", @cell = "Active (Needs Att.)"))
Answers
-
Give this a shot:
=COUNTIF([IEP Status]:[IEP Status], OR(@cell = "NEW (not signed)", @cell = "Active (Needs Att.)"))
-
that's quite a bit of additional formatting I don't quite understand... but it works great
thanks you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!