How do I automatically un-flag?

KBSheetBI

If planned start is in the past and start date is blank. Late start populates a red flag a red flag.

This is the formula: =IF(AND(ISBLANK([Start Date]@row), [Planned Start Date]@row < TODAY()), 1, 0)

When a cell says "completed" in the status column, how do I get it to unflag?

Find more posts tagged with

Accepted answers

John_Foster

Hi @KBSheetBI,

Try this formula.

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

Hope this helps!

John

John_Foster

Hi @KBSheetBI,

You are welcome. For the rejected you can use the below, there may be a better way but this is what I would use.

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

John

All comments

John_Foster

Hi @KBSheetBI,

Try this formula.

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

Hope this helps!

John

KBSheetBI

Thank you, Sir!!

KBSheetBI

@John_Foster This works great! What do I need to add to the formula when status is rejected? would want it to remove the flag just like it does when completed

John_Foster

Hi @KBSheetBI,

You are welcome. For the rejected you can use the below, there may be a better way but this is what I would use.

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

John

KBSheetBI

@John_Foster it works. You are the man!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.