Date Formula Question

Hello, I am creating a formula to pull the month out and then if the date is blank to have the field be blank. Here is the formula I am using:

=MONTH([Activity End Date]@row, IF(ISBLANK([Activity End Date]@row, " ")))

However, I am receiving an "Invalid Data Type" response. I've attached a screen print. If the Activity End Date is blank, I want the "Month" column to be Blank.

Thank you!

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!