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
Help Article Resources
Check out the Formula Handbook template!