Workday formula not working

ljbmhe
ljbmhe ✭✭
edited 09/27/22 in Formulas and Functions

I have a date linked in from a separate schedule smartsheet and want to use the WORKDAY formula to calculate 10 business days from that date, but am getting an error and can't figure out what I'm doing wrong. The following formula is returning an #INVALID DATA error:

=WORKDAY([IDTF START]1, 10)

What am I doing wrong?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!