If Or function including date

HI Team,

I am trying to return Active or Inactive based on two criteria one being today's date being < the end date and the other based on a check box. I can mix it up and get the formula to work for either the date or the tick box but not for both.

=IF(OR([Formula check box]@row = 0, TODAY() < [TBA actual end date]@row), "Active", "Inactive")

Both of these photos should be returning an Inactive result. Where am I going wrong??

Find more posts tagged with

Accepted answers

All comments

AravindGP

Hi @Jamie Teut

If you're looking for both conditions being met, the formula should be

=IF(AND([Formula check box]@row = 0, TODAY() < [TBA actual end date]@row), "Active", "Inactive")

Jamie Teut

I'm looking to show an inactive result when the end date is in the past OR if it is not expired and the 'Formula check box' is ticked I need to show an inactive result too

AravindGP

Hi @Jamie Teut

Please share the names of the columns as in your sheet that you want to check and the logic. Trying to figure out what constitutes as not expired.

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.