Returning a Due Date Based on Multiple Criteria

Question

Hello,

I want to return an Investigation Target Due Date based on a record Classification

If Classification is Major or Critical, the Target Due Date is the Awareness Date + 45 Days

If the Classification ia Minor, the Target Due Date is the Awareness Date + 60 Days

Here is what I have, but it is showing as #UNPARSEABLE.

=IF(OR(Classification@row  = "Major", Classification@row  = "Critical"), [Awareness Date]@row  + 45), IF(Classification@row  = "Minor"), ([Awareness Date]@row  + 60))

Please help.

Thanks

anmsaif · Answer

Correction:

=IF(OR(Classification@row  = "Major", Classification@row  = "Critical"), [Awareness Date]@row  + 45, IF(Classification@row  = "Minor", [Awareness Date]@row  + 60))

Problems:

—> First if () was closed earlier than its supposed to be.

—> The second  if () was outside the first instead of being the false condition

Note: I have created end to end solutions for over 50 different processes and looking for new consulting options. Please reach out saifamansf@gmail.com for a free 15 minutes review.

Paul Newcome · Answer

As mentioned, the parenthesis are the issue causing that particular error.

I just wanted to provide a quick suggestion to simplify the formula a bit (this assumes only those three options are available for Classification@row).

=[Awareness Date]@row + IF(Classification@row = "Minor", 60, 45)

Anjanesh Vaidya · Answer

Hi @Doris Fomulu,

The issue in your formula are those extra parentheses because of which you are getting that error.

Please use the formula below:

=IF(OR(Classification@row  = "Major", Classification@row  = "Critical"), [Awareness Date]@row  + 45, IF(Classification@row  = "Minor", [Awareness Date]@row  + 60))

This article will be useful for understanding and resolving error messages going forward.
Formula error messages