If a cell is empty, then I want today, otherwise, use the date in the cell
Options
I keep getting unparseable...
=IF([Date Position Filled]2 ISBLANK, TODAY(),[Date Position Filled]2)
Can anyone say what is wrong?
Best Answers
-
Try this...
=IF(ISBLANK([Date Position Filled]2), TODAY(), [Date Position Filled]2)
-
My HERO!!!! thank you so much!!
Answers
-
Try this...
=IF(ISBLANK([Date Position Filled]2), TODAY(), [Date Position Filled]2)
-
My HERO!!!! thank you so much!!
-
Happy to help! 👍️
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!