IF(AND(OR Statement Help
I want to write a statement to determine if a record was extended on time?
I have a calculated column that determines if a record extension is required [Extension Required] , and the responses are Yes or No.
I also have columns for the record [Due Date], and the [Extension Approval Date]
Logic: If the value in the [Extension Required] column is Yes, AND either the [Extension Approval Date] is greater than the [Due Date], OR [Extension Approval Date] is "N/A", THEN the record was not extended on time.
I tried the following statement, but it returned: #UNPARSEABLE
=IF(AND(OR([Extension Required]@row=Yes, ([Extension Approval Date]@row < [Due Date]@row) [Extension Approval Date]@row ="N/A"), "No", "Yes"))
Please Help, Thank you
Answers
-
Hi Doris, Try this one:
=IF(AND([Extension Required]@row = Yes, OR([Extension Approval Date]@row > [Due Date]@row,[Extension Approval Date]@row ="N/A")), "No", "Yes"
It's all in how you nest the OR statement. It has to be within the AND statement to make either of the OR and the Extension required row = yes calculate together. Let me know if it worked!
-
Hi @Mike Wilday,
Thank you for responding. I posted the formula as shown below,
=IF(AND([Extension Required]@row = Yes, OR([Extension Approval Date]@row > [Due Date]@row,[Extension Approval Date]@row ="N/A")), "No", "Yes")
and it still returned #UNPARSEABLE.
I checked all the column names and no errors there. Any other thoughts? THANK YOU!!!
-
Hi @Doris F ,
Try putting quotation marks around your first Yes (in the AND statment). That should help!
Best,
Heather
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!