Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

In a row... A field gets automatic input based on previous fields (A condition for automated input using text)

Topic Labels: Formulas
295 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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!

1 Reply 1

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())