Date Formula Q

Options

Hi All.

Pretty easy one for you all, I think.

I'm trying to create a formula where in if the date in the "Date" column is < 12/31/2023, value of X is returned if true, and Y is returned if false (i.e, after the new year). Keep getting #UNPARSEABLE error. This is one that is easy in Excel, but can't get to work in SS.

=IF(Date@row<12/31/2023,x,[y])

Answers

  • John_Foster
    John_Foster ✭✭✭✭✭✭
    Options

    Hi @mattimer,

    Try this formula, it replaces your date of 12/31/2023 with a date creator function.

    =IF(Date@row<DATE(2023,12,31),x,[y])

    The date creator takes three arguments which are Year, Month then Day.

    Hope this helps!

    John

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!