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!

Genevieve P.

Hey @Zachery Taylor

Were you able to sort this out? It looks like there's just a rogue comma at the end of your WORKDAY statement that needs to be removed 🙂

Try:

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

Cheers,
Genevieve