ISO - Simple At Risk Formula

Hi Friends,

Looking for AT RISK Formula -

I'd like a formula that says IF Start Date is less than today (in the past) and Status ISBLANK then AT RISK flag is flagged. Below is a completely wrong formula - I just don't know how to get the ISBLANK in there.

Can anyone help? Formula challenged but love learning!

=IF(AND([Start Date]@row < TODAY(), Status@row = ISBLANK), 1, 0)

desired result is that the flag would be flagged (red)

Thanks! Lynda

Find more posts tagged with

Formulas

Accepted answers

Dan Berens

Hi Lynda,

Instead of ISBLank, you might use null. (Status@row = ""),1,0)

All comments

Dan Berens

Hi Lynda,

Instead of ISBLank, you might use null. (Status@row = ""),1,0)

Lynda Ross

@Dan Berens, Thank YOU! Immediate help! Amazing! 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.