IF & Workday Formula

TAbs

Hello, I had a working WORKDAY formula, but when I tried to add the IF statement for blanks it broke the formula.

=IF([Expected DEL Date]@row = "", "", =WORKDAY([Expected DEL Date]@row, 2, {Holidays Range 3}))

Toufong Vang

Hi, @TAbs, remove the "=" that appears before WORKDAY() and your formula should work again.

= IF([Expected DEL Date]@row = "" , "", WORKDAY([Expected DEL Date]@row, 2, {Holidays Range 3}))

https://help.smartsheet.com/function/workday

Toufong Vang

Hi, @TAbs, remove the "=" that appears before WORKDAY() and your formula should work again.

= IF([Expected DEL Date]@row = "" , "", WORKDAY([Expected DEL Date]@row, 2, {Holidays Range 3}))

https://help.smartsheet.com/function/workday

TAbs

I was overthinking it. Thank you!