IF / THEN Formula help

AndrewWalter ✭✭✭
edited 12/09/19 in Formulas and Functions


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.





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!