Hello! I have a large sheet that I am working with. I want to create a formula that returns an "X" if the following criteria are met: * Column "Date" is less than today (in the past) * Column "Project ID" is blank/not populated I currently have the following formula that is returning an Incorrect Argument Set: =IF(AND([Date]@row < TODAY(), [Project ID]@row, "X", "")) Any help would be appreciated!

IF statement with 2 variables, cannot get it to work

Hello!

I have a large sheet that I am working with. I want to create a formula that returns an "X" if the following criteria are met:

Column "Date" is less than today (in the past)
Column "Project ID" is blank/not populated

I currently have the following formula that is returning an Incorrect Argument Set:

=IF(AND([Date]@row < TODAY(), [Project ID]@row, "X", ""))

Any help would be appreciated!

Find more posts tagged with

Accepted answers

Nick Korna

Hi @SASardy,

The formula you would want for this is:

=IF(AND(ISBLANK([Project ID]@row), (Date@row < TODAY())), "X", "")

Sample:

Hope this helps. If you've any questions etc. then just post! 😊

All comments

Nick Korna

Hi @SASardy,

The formula you would want for this is:

=IF(AND(ISBLANK([Project ID]@row), (Date@row < TODAY())), "X", "")

Sample:

Hope this helps. If you've any questions etc. then just post! 😊

SASardy

This did it Nick! Thank you for the quick response. I tried ISBLANK first and it was not working either but your version did!

Nick Korna

No problem, happy to have helped! 😊

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.