if / and / isblank formula

If my status is closed, but I did not put a date in the date closed column, I need it flagged. Can someone help write this formula? I am using =IF(AND(ISBLANK([Date Closed]@row), Status@row, "Closed"), "High", "Low") and get the error #INVALID DATA TYPE

Find more posts tagged with

Formulas

Accepted answers

Nick Brisson

Your formula should work, it sounds like the cell you are entering the formula into is not set to Text/Number

The below formula would work as well

=IF(AND([Date Closed]@row = "", Status@row = "Closed"), "high", "low")

All comments

Nick Brisson

Your formula should work, it sounds like the cell you are entering the formula into is not set to Text/Number

The below formula would work as well

=IF(AND([Date Closed]@row = "", Status@row = "Closed"), "high", "low")

Chevon Brownell

That worked. Thanks!

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.