Trying to Combine a Workday Formula with a Checklist (IF) formula

G_Alchemist

Hello, see screenshot below. Trying to make a formula to calculate the Due Date 15 days prior to the Date column if the L column is checked. This is what I have so far. All attempts are either coming back to #Date Expected result or #invalidoperation:
=IF(L@row = 1, "Yes", "No") = WORKDAY(Date@row, -15)

Kelly Drake

Your syntax is not correct and the errors are caused by different things. I'm suprised it's not throwing you an #UNPARSABLE.

For syntax details you can read here https://help.smartsheet.com/function/if . But the "Yes", "No") part should make the = WORKDAY part not run at all.

#DATE EXPECTED is related to the formula syntax issue - in your screenshot, the L@row is checked (aka it = 1) so the formula is putting Yes into the date column.
https://help.smartsheet.com/articles/2476176-formula-error-messages#toc--date-expected

#INVALID DATA TYPE is likely related to the Date@row being blank. https://help.smartsheet.com/articles/2476176-formula-error-messages#toc--invalid-data-type

Try this..
=IFERROR(IF(L@row = 1, Date@row - 15), "TBD")

It will leave the Due Date blank where the L@ row is not checked, and it will give you 15 calendar days prior to the Date@row column when that is populated. Where Date@row is blank and L@row is checked it should return TBD.