Return current month if cell value is blank

Options

Hi everyone. I am hoping you can assist me. I have a column titled "Transaction Date" and am creating a helper column so we can display a chart on a dashboard. I am trying to get the formula that if the Transaction Date cell value is blank it returns the current month in "mmm" format. The formula I have is below and it returns a blank value in the helper column when the Transaction Date cell is empty, when I want it to display the current month. The Transaction Date column is formatted as a date column.

My current formula thats not working is:

=IF([Transaction Date]@row <> "", IF(MID([Transaction Date]@row, 1, 2) = "12", "Dec", TODAY()))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!