Create a new column based on if column X has a value

[mlim0806]

Hi community, 

I'm trying to find a formula that will look at a date column, and if there is a date value in the cell, then create a new column that says 'yes' or 'no'.

In the sample dataset attached, I have a tab for the input data, and I want to create a new 'yes/no' column, "if there is a value in the date column, then yes, else no". The output tab is the desired output. I've tried the if contains formula, but can't figure out how to call out "date value" or "any value".   

(I have 2020.2 version, and cannot open some features in the newer versions)

[caltang · Accepted solution]

Do it this way:

IF IsNull([Date])
THEN "No"
ELSE "Yes"
ENDIF

[mlim0806]

that worked! Much easier to look for the nulls vs. a value, thank you!