Date Column 1 < Gate Column 2 = At Risk

I have a Target Date column and the typical Finish column. I am looking for a formula that will tell me if Target Date is less than Finish Date mark the cell AT RISK. But if the Target Date cell is blank leave it blank.

=IF([Target Date]@row > [Finish]@row , "Yes", "AT RISK")

I can't get the ISBLANK to work.

Find more posts tagged with

functionality

Accepted answers

All comments

Jake Gustafson

=IF(ISBLANK([Target Date]@row ), "", IF([Target Date]@row > Finish@row , "Yes", "AT RISK"))

Try that. May want to assess ≥ in your equation or writing the reverse and have additional options if it isn't at risk (i.e., in process, done).

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.