Return current month if cell value is blank

Peppey

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

John_Foster

Hi @Peppey,

There are a couple of ways to do this, I have found an old post that details them and has some great options.

https://community.smartsheet.com/discussion/91717/how-can-i-get-the-month-text

Hope this helps!

John

Peppey

Thanks sir for the information. I have tried this formula but i am still getting an INVALID ERROR when the transaction date column is blank

IF(ISBLANK([Transaction Date]@row), TODAY(), MONTH([Transaction Date]@row))