Help with date formate

Options

I have my months extracted from a date column using =Left(EISD@row,2)

I need a formula to evaluate my month column, if it's 01-06 it returns an S, if its 07-12 (or <=7) then it returns an F.

Best Answer

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭
    Answer ✓
    Options

    Assuming your result will only ever be 01-12, this should do the trick. The VALUE() function may not necessarily be needed, but I'm not sure what type of date you are pulling the month information from and it isn't going to hurt anything.

    =IF([Month Column]@row <> "", IF(VALUE([Month Column]@row) < 7, "S", "F"))

    Replace [Month Column] with your column name.

Answers

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭
    Answer ✓
    Options

    Assuming your result will only ever be 01-12, this should do the trick. The VALUE() function may not necessarily be needed, but I'm not sure what type of date you are pulling the month information from and it isn't going to hurt anything.

    =IF([Month Column]@row <> "", IF(VALUE([Month Column]@row) < 7, "S", "F"))

    Replace [Month Column] with your column name.

  • jpaul
    jpaul ✭✭✭✭
    Options

    Thank you Carson, that worked perfectly.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!