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

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭
    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

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭
    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