Flag Formula

Hello,

I am attempting to create a formula that if a presentation date = today and the status is either "Not started" or "In Progress" the flag will go off. I feel I am so close but keep getting an error.

=IF([Presentation Date]@row = TODAY(), Status@row = "Not Started", 0, OR([Presentation Date]@row = TODAY(), Status@row = "In Progress", 0))

Find more posts tagged with

Accepted answers

David Tutwiler

I think you're missing some ANDS and ORS. Try this one. It will set the flag to 1 if the conditions are met and 0 if they are not.

=IF(OR(AND([Presentation Date]@row = TODAY(), Status@row = "Not Started"), AND([Presentation Date]@row = TODAY(), Status@row = "In Progress")), 1, 0)

All comments

David Tutwiler

I think you're missing some ANDS and ORS. Try this one. It will set the flag to 1 if the conditions are met and 0 if they are not.

=IF(OR(AND([Presentation Date]@row = TODAY(), Status@row = "Not Started"), AND([Presentation Date]@row = TODAY(), Status@row = "In Progress")), 1, 0)

Michele Thomas

Thank you so much David. Worked perfectly!!!

David Tutwiler

Awesome! Glad to hear it.

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.