Formula help = if date contains TBD, leave blank



I'm struggling with the 3rd part of my formula.

I need to have the formula calculate:

  1. A date from the entered work week;
  2. be left blank if no work week is entered
  3. and leave blank if TBD is listed in the work week column

1 & 2 work using this formula:

=IF(ISBLANK([Work Week]@row), "", (DATE(year@row, 1, 1) + 7 * ([Work Week]@row) - 8))

Everything I've tried has not yet worked - can you help?



Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!