Help with an IF/AND/OR formula


I am trying to write a formula to return today's date when all of the following are met:

Column 1 is not blank

Column 2 is not blank

Column 3 is either Kangaroo or Platypus

If any of these is untrue, then I would like the cell to remain blank.

Here is my attempt which returns an incorrect argument error:

IF(AND([Column 1]1 <>"", [Column 2]1 <>"", OR([Column 3]1 = "Kangaroo", [Column 3]1 = "Platypus"), TODAY(), "")

What am I doing wrong? 🤔

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!