Invalid Value ERROR

Options

Answers

  • WinaHath
    WinaHath ✭✭✭✭
    Options

    please also help me; this formula is returning an "invalid value. The column is a Date

    =IF([Date of Last Invoice]@row < DATE(YEAR(TODAY()) - 2, MONTH(TODAY()) + 6, DAY(TODAY())), "Inactive", "Active")

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!