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

sjohanson · 11/19/24

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.

Carson Penticuff · 11/19/24

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"))))))))))))

Matt Johnson · 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:

@Alison Clancy bonus points for #AI use?

Carson Penticuff · 11/19/24

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"))))))))))))

Matt Johnson · 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: