Formula Assistance for Returning a Due Date

Zachery Taylor

Hello,

I feel like I'm almost there on the formula, but can't figure out why WORKDAY is causing a #unparseable error.

Function of the formula: If urgent flag is marked on the row I want the due date to be due on the same date that was by the 'Date Created' column type.

If the flag is not marked, I want the formula to calculate the due date to be due in 2 days from when the Date Created field was generated.

Here is my current formula:

=IF(URGENT@row=1,Created@row,Created@row+WORKDAY(Created@row,2,)

I can make the formula work with just Created@row +2 as part of the false statement, but I would prefer the due date not to land on a weekend.

Thanks for reading and the assistance!