Invalid data type for Date Formula


I am trying to figure out what I am doing wrong. I keep getting invalid data type and I am not sure why, the source column and formula column are both set to date columns.

Here is the formula I am using, =WORKDAY([Date January Late Notification Sent]@row, 10), I am trying to figure out 10 working days from the date listed in the "Date January Late Notification Sent" Column, which is set as a date column in properties.

Best Answer

  • JamesB
    JamesB ✭✭✭✭✭✭
    Answer ✓

    @CaraBart28 Try putting a date in your Date January Late Notification Sent cell. Since your formula has no data to reference it errors out.

    you could do this.

    =IFERROR(WORKDAY([Date January Late Notification Sent]@row, 10)," ")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!