IF statement with 2 variables, cannot get it to work

SASardy ✭✭✭✭


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!

Best Answer

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Answer βœ“

    Hi @SASardy,

    The formula you would want for this is:

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


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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!