IF / THEN Formula help

AndrewWalter

Hello,

I am new to Smartsheets and i am trying to do the following.  I have a column (column 1) which is a text cell and a second column (column 2) which is date format.  I am trying to say that if column 1 is not empty then return the month value of the date in column 2.

My formula currently is as follows, i believe i have the month value correct but having trouble with the IF the column 1 is not empty THEN section

=IFERROR(IF(NOT(ISBLANK([column1]@row, 0)), MONTH([column2]@row), ""))

Any help would be appreciated.

Thanks

 

sean59916

Hi Andrew - 

Try the formula:

=IFERROR(IF(ISBLANK([Column1]@row), "", MONTH([Column 2]@row)), "")

I hope this helps?

 

Sean

L_123

Your original formula is actually very close.

 

Original:

=IFERROR(IF(NOT(ISBLANK([column1]@row, 0)), MONTH([column2]@row), ""))

Corrected

=IFERROR(IF(NOT(ISBLANK([column1]@row)), MONTH([column2]@row)), "")

Just one incorrectly placed parenthesis at the end, and the , 0 is incorrect

AndrewWalter

Thanks very much - appreciate the help!