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!

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

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)

All comments

Paul Newcome

=IF(ISBLANK([Manual Date]@row), DATEONLY([Created]@row), [Manual Date]@row)

jenni536

@Paul Newcome I didn't have the columns set as date types, but just updated them and that worked! Thank you so much!

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.