I need to determine if a date column is blank then it returns a message

Hello,

I want help with a formula to return a message that says met goal if the date is blank or did not meet if the date is populated. I tried this formula but it is not working it returns #Unparseable

=IF(ISDATE([Request Intake Range 9]1:[Request Intake Range 9]22), "met goal", "did not meet")

So essentially I want to say if the cell has a date populated then this message will be shown

thank you,

Find more posts tagged with

Sheets

Formulas

Cell linking

Accepted answers

All comments

Tim Shaded

Hi,

This could be done, but there are a couple caveats.

Date columns cannot hold a formula. The formula will have to be on another column for that row and could be even converted to be Column Formula.
The actual column were the date is supposed to be entered would be best to limit to dates only. This can be done through properties on that column with a checkmark "Restrict to dates only".

Assuming that the values need to be checked per row, the below formula should work to provide the desired effect:

=IF([Request Intake Range 9]@row = "", "did not meet", "met goal")

HFletcher

Thank you! Its actually for a metrics sheet that is referencing another table so hopefully this yields what I want. It's for a summary

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.