Formula Tool - comparing if two columns have values

Hello

Is there a formula to compare if column 1 has a value and if column 2 has a value then output True in a new column or else output False.

A couple of additional items to keep in mind is that data types are different in both columns so i am not doing if column 1 equals column 2. and column 1 has dates in multiple formats. I have created column 2 to standardize the date formats but want to do a check that if column 1 has a value then i need column 2 to have a value as well.

Thank you in advance.

Date Time

Data Investigation

Accepted answers

If you're trying to see if the two columns have any value as opposed to a specific value then use

If not IsEmpty([Column1]) and not IsEmpty([column2]) then

True

Else

False

Endif

Dan

All comments

@PDS4545 - Yeah you can use the formula tool. Example would be:

result:

Hope that helps!

If you're trying to see if the two columns have any value as opposed to a specific value then use

If not IsEmpty([Column1]) and not IsEmpty([column2]) then

True

Else

False

Endif

Dan

This worked. Thank you so much!

Quick Links

Tags

This months top contributors

AkimasaKajitani 387

Hollingsworth 335