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


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)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!