IFS Statement
I have the following equation I am trying to get working: =COUNTIFS({Range 1}, =1, {Range 2}, IFERROR(YEAR(@cell), 0) = 2018, {Range 2}, IFERROR(MONTH(@cell), 0) = January, {Range 3}, OR(@Cell="", @Cell="")) The equation has worked in the past without the or statement at the end. It was once looking for one value here, now I want it to look for multiples. Is this possible?
Comments
-
I've always had trouble using OR or AND statements in Countifs. A simple solution would be to manually add an additional countifs to the end of the first one using the + sign.
=COUNTIFS({Range 1}, =1, {Range 2}, IFERROR(YEAR(@cell), 0) = 2018, {Range 2}, IFERROR(MONTH(@cell), 0) = January, {Range 3}, @Cell="")+countifs({Range 3}@Cell="")
But what I don't quite get is why you are looking for duplicate blanks. Both of those OR statements are looking for the same thing. Is that intended?
-
That was my fault, I was unclear on that. I am looking for two different names, I just erased them from the equation. That works, equations are long, but exactly what I was looking for. Thanks!
-
Glad I could help you out! Happy Smartsheeting.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 422 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 143 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!