Oct 15, 2020 10:26 AM
Trying to automate a Field input based on the 2 previous field inputs. (In the same row)
If (Field X = True) AND (Field Y = True) THEN (Field Z = True)
(another example would be:)
If (Field X = False) AND (Field Y = False) THEN (Field Z = False)
Can this be done? Many thanks!
Oct 15, 2020 10:33 AM
Yep. If you’re being literal:
IF(AND({Field X} = TRUE(), {Field Y} = TRUE()), TRUE(), FALSE())
If Field X or Y reterun something other than booleans:
IF(AND({Field X} = "something", {Field Y} = "something else"), TRUE(), FALSE())