IF Statements - looking up through CONTAINS

I am getting an #IncorrectArgumentSet on this formula. I do realize I am trying to include a lot here.

What I am trying to do: Create an if statement that marks LATE if true, and On Time if false with two criteria: 1. looking up via Contains to make sure the project name is taken into account 2. if there are any lates within that project range. Any help is much appreciated.

#IncorrectArgumentSet formula:

=IF(AND(CONTAINS([Project Name]@row, {Tracker - Range 2})), (CONTAINS("LATE", {Tracker - Range 5})), "LATE", "On Time")

Find more posts tagged with

Accepted answers

Kaveri Vipat

Hi MegBurns23

Please you can try this formula

=IF(AND(CONTAINS([Project Name]@row, {Tracker - Range 2}), CONTAINS("LATE", {Tracker - Range 5})), "LATE", "On Time")

I hope this helps!

All comments

MegBurns23

Anyone, help?

Kaveri Vipat

Hi MegBurns23

Please you can try this formula

=IF(AND(CONTAINS([Project Name]@row, {Tracker - Range 2}), CONTAINS("LATE", {Tracker - Range 5})), "LATE", "On Time")

I hope this helps!

MegBurns23

Oh my, I got lost in ()s, thank you so so so so much!

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.