Jun 03, 2019 02:12 AM
Hi!
I’m using airtable in the hiring process (kind of like a scorecard) and I was wondering how to write a function to produce a recruitment decision based on two airtable columns.
Here’s the idea: If {column 1} = ‘accept’ AND {column 2} = ‘accept’, than ‘proceed’. Otherwise ‘no’.
Is there a way to write a logical function for that?
Thanks in advance! :slightly_smiling_face:
Nadia
Jun 03, 2019 04:43 AM
Hi @Nadia_Gorchakova and Welcome to Airtable Community :grinning_face_with_big_eyes:
Try this.
IF({column 1}=“no”,“no”,IF({column 2}=“no”,“no”,“accept”))
Replace the “no”'s with whatever you’re using for the non accepted.
Jun 03, 2019 07:36 AM
Here’s how to do it using AND:
IF(AND({column 1} = "accept", {column 2} = "accept"), "proceed", "no")
Jun 03, 2019 08:30 AM
@Justin_Barrett Thanks for posting :grinning_face_with_big_eyes:
I find myself staying away from the AND formula only because I get tripped up as to where to place them.
Jun 06, 2019 01:44 AM
Thank you friends! :slightly_smiling_face: