Need a column to auto populate the month NAME when the date column next to it is selected.

sjohanson
sjohanson ✭✭
in Formulas and Functions

What I need: When final complete DATE is entered, the final completion MONTH column lists the month associated.

For this example: 11/15/24 was entered in the Final completion DATE column. I need the final completion MONTH column to auto reflect NOVEMBER.

image.png

· Share on FacebookShare on Twitter

Answers

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭

    If you are looking for the numeric month… short and sweet:

    =IF(ISDATE([Final Completion Date]@row), MONTH([Final Completion Date]@row), "")

    If you want the month to appear as text, not quite so short:

    =IF(ISDATE([Final Completion Date]@row), IF(MONTH([Final Completion Date]@row) = 1, "January", IF(MONTH([Final Completion Date]@row) = 2, "February", IF(MONTH([Final Completion Date]@row) = 3, "March", IF(MONTH([Final Completion Date]@row) = 4, "April", IF(MONTH([Final Completion Date]@row) = 5, "May", IF(MONTH([Final Completion Date]@row) = 6, "June", IF(MONTH([Final Completion Date]@row) = 7, "July", IF(MONTH([Final Completion Date]@row) = 8, "August", IF(MONTH([Final Completion Date]@row) = 9, "September", IF(MONTH([Final Completion Date]@row) = 10, "October", IF(MONTH([Final Completion Date]@row) = 11, "November", "December"))))))))))))

    · Share on FacebookShare on Twitter
  • Matt Johnson
    Matt Johnson ✭✭✭✭✭✭
    edited 11/19/24

    Hi @sjohanson

    Here you go:

    =IF(MONTH([Final Completion Date]@row) = 1, "January", IF(MONTH([Final Completion Date]@row) = 2, "February", IF(MONTH([Final Completion Date]@row) = 3, "March", IF(MONTH([Final Completion Date]@row) = 4, "April", IF(MONTH([Final Completion Date]@row) = 5, "May", IF(MONTH([Final Completion Date]@row) = 6, "June", IF(MONTH([Final Completion Date]@row) = 7, "July", IF(MONTH([Final Completion Date]@row) = 8, "August", IF(MONTH([Final Completion Date]@row) = 9, "September", IF(MONTH([Final Completion Date]@row) = 10, "October", IF(MONTH([Final Completion Date]@row) = 11, "November", "December")))))))))))

    I can't take the credit, Smartsheet's AI formula generator did this based on this request:

    image.png

    @Alison Clancy bonus points for #AI use?

    Matt Johnson

    Sevan Technology

    Smartsheet Aligned Partner

    · Share on FacebookShare on Twitter
  • sjohanson
    sjohanson ✭✭

    Thank you!!!!

    · Share on FacebookShare on Twitter
  • Alison Clancy
    Alison Clancy Employee
    https://community.smartsheet.com/discussion/comment/462721#Comment_462721

    haha you get 1000 bonus Alison points! Big Champion behavior. 🎉

    Meet the Overachievers + Community Champions 🤩

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!