Using IF

Mer

Can you please suggest what is wrong with this formula? (Priority Level and Modified are both columns. Priority Level is a dropdown, Modified is the automated modified date.

=IF([Priority Level]@row, ="High: Within 2 business days", (Modified)@row)

I am eventually trying to get the formula to add 2 days to the modified date if level is high, 5 days if "Medium," etc. Thank you!

Carson Penticuff

An extra comma and some extra parens:

=IF([Priority Level]@row ="High: Within 2 business days", Modified@row)

If the actual name of the Modified column DOES have the open and close parens, you will need to enclose it in square braces. [(Modified)]@row

Carson Penticuff

An extra comma and some extra parens:

=IF([Priority Level]@row ="High: Within 2 business days", Modified@row)

If the actual name of the Modified column DOES have the open and close parens, you will need to enclose it in square braces. [(Modified)]@row