Should I use IF or IF(AND....or Something Else?
Good afternoon everyone.
I was hoping someone could help me with a formula I'm having an issue with I tried a few different equations. I found by removing one of the parts of the equation, I received a Yes response, however, when I tried adding in the other part, I received an error of either "Incorrect Argument Set" or "Unparseable". The equations I tried are attached.
Best Answer
-
Hi, Laurie. I think your issue may be parentheses placement. Try this:
=IF(AND(Open@row = "Closed", Days@row < 30), "Yes", "No")
or try
=IF(AND(Days@row <30, Open@row = "Closed"), "Yes", "No")
Answers
-
Hi, Laurie. I think your issue may be parentheses placement. Try this:
=IF(AND(Open@row = "Closed", Days@row < 30), "Yes", "No")
or try
=IF(AND(Days@row <30, Open@row = "Closed"), "Yes", "No")
-
Thank you so much Danielle! The first formula worked perfectly. 😃
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 304 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!