Yield year if criteria is between two dates in two columns.

Options

Hello,

I am trying to yield the Year if Start date is greater than or equal to 1/1/2023 but pre-marketing date is less than or equal to 12/31/2023.

I was fine with a simple year in a single column but am stumped with yielding year between two dates in two columns.

Thanks!

Tags:

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓
    Options

    You can nest an IF function inside of the YEAR function to choose which date to output.

    =IF([Pre-Marketing Date]@row <> "", [Pre-Marketing Date]@row, [Start Date]@row)


    Now that we have the IF outputting the date we want to use, we wrap the whole thing in a YEAR function.

    =YEAR(IF([Pre-Marketing Date]@row <> "", [Pre-Marketing Date]@row, [Start Date]@row))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!