Invalid Data Type

Options

Can anyone help with this formula.

Answers

  • Jason Tarpinian
    Jason Tarpinian ✭✭✭✭✭✭
    Options

    You can just wrap it all up in an IFERROR to get rid of the #ERROR.

    =IFERROR(IF(ISBLANK([Pre-Sale Contract Date (TBD Convert)]@row), NETDAYS([Lot Hold Date]@row, TODAY()), NETDAYS([Lot Hold Date]@row, [Pre-Sale Contract Date (TBD Convert)]@row)), "Missing Dates")

    Then if any of the dates are missing it would return "Missing Dates" instead of the error message.

    Jason Tarpinian - Sevan Technology

    Smartsheet Aligned Partner