Formula Tool - comparing if two columns have values

[PDS4545]

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.

[usmanbashir]

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

 

result:

 Hope that helps!

[danilang · Accepted solution]

Hi @PDS4545 

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

[PDS4545]

This worked. Thank you so much!