IF statement with 2 variables, cannot get it to work

SASardy

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!

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! 😊

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! 😊