ISBLANK formula not returning data when cell is blank
I have an automatically generated date column in my sheet 'Created Date'. I want to be able to override this date with a manually entered date 'Manual Date'. I created a new column called 'Inquiry Date' and am using this formula:
=IF(ISBLANK([Manual Date]@row), [Created]@row, [Manual Date]@row)
I want the formula to pull the 'Manual Date' if it exists and if that field is blank, then I want it to pull the 'Created Date'.
This formula works great when the 'Manual Date' has a value, but when it's blank, I get the following error: #INVALID COLULMN VALUE
I'm sure I'm missing something really simple here, but I'm stumped. Any suggestions?
Thanks in advance!
Best Answer
-
Make sure the Manual Date column and the column you are putting the formula in are both set as date type columns. If that still doesn't help, you will need to incorporate the DATEONLY function to strip just the date out of the date/time stamp.
=IF(ISBLANK([Manual Date]@row), DATEONLY([Created]@row), [Manual Date]@row)
Answers
-
Make sure the Manual Date column and the column you are putting the formula in are both set as date type columns. If that still doesn't help, you will need to incorporate the DATEONLY function to strip just the date out of the date/time stamp.
=IF(ISBLANK([Manual Date]@row), DATEONLY([Created]@row), [Manual Date]@row)
-
@Paul Newcome I didn't have the columns set as date types, but just updated them and that worked! Thank you so much!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!