Formula tool if then statement giving 0 values in a column instead of string

[ShantanuDagar]

Hey,

I am working on a dataset with 3 columns.

Based on the empty cells in 1st 2 columns, value in 3rd needs to be updated to available, not available.

If both column 1, column 2 empty, then column 3 should show available, and in all other cases not available.

The if then condition using formula tool is giving me 0 values in the column instead.

Using this...IF (IsEmpty([Column 1]) AND IsEmpty([Column 2])) THEN [column 3]= "Not Available" else [column 3] = "Available" endif

[Felipe_Ribeir0 · Accepted solution]

Hi @ShantanuDagar 

Try this one

IF (IsEmpty([Column 1]) AND IsEmpty([Column 2])) THEN "Available" else "Not Available" endif

[Sarreddy]

@ShantanuDagar