EQUALS

EQUALS(data1, data2);

Formula for comparing data. Used within other formula instead of '=' which is reserved as assign parameter.

 

Example:

##CASE(EQUALS("Status", 'Closed'), 0, EQUALS("Status", 'Open'), 1, 2)

 

If "Status" has the value "Closed" it will return the result "0".

If "Status" has the value "Open" it will return the result "1".

If "Status" has neither the value "Closed" nor the value "Open" it will return the result "2".