How to add date condition to IF/AND equation

I have multiple IF/AND equations in a column formula. I want to add a condition to the IF/AND equations to apply before a certain date in a column(Date of Shoot). This is an example of one of the formulas:

IF(AND(Talent@row = "Agency", Time@row = "Half", [Date of Shoot]@row < DATE(2023, 9, 16), 250

But is shows as "incorrect argument"

Find more posts tagged with

Accepted answers

DKazatsky2

Hi @mpajuelo

You are missing 2 closed parens. Try the below.

=IF(AND(Talent@row = "Agency", Time@row = "Half", [Date of Shoot]@row < DATE(2023, 9, 16)), 250)

Hope this helps,

Dave

All comments

DKazatsky2

Hi @mpajuelo

You are missing 2 closed parens. Try the below.

=IF(AND(Talent@row = "Agency", Time@row = "Half", [Date of Shoot]@row < DATE(2023, 9, 16)), 250)

Hope this helps,

Dave

mpajuelo

It works, thank you!

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.