Creating a IF(AND(ISDATE formula to check a box

Options

Hi All,


I am trying to write a IF(AND(ISDATE formula to check a box I have read through several post but dont see and example of doing all three of these functions nested together. I get either unparsable or Invalid argument on my attempts.


Goal: in my data set I dont care what the date is just that it is a date (anydate) I am using a Vlookup in COLUMN2 to pull in the dates, and the rows with out matching Vlookup partners come back with #NO MATCH so I am trying to get those rows with part 2 of the formula. If COLUMN1 AND 2 dont meet the criteria then dont check the box.

If COLUMN1 = Foreign and COLUMN2 = a date then check the box

If COLUMN1 = Foreign and COLUMN2 = not a date then dont check the box

Others wise dont check the box.


Thanks

Lisa

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!