Using IF
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!
Best Answer
-
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
Answers
-
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