IF formula for missing fields

Topic Labels: Formulas
888 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

Hey Airtable friends,
I was wondering if my problem had a solution so here it is.
I ask questions to users who can answer them or decline (blank field if they do so) and I would like to know if I could create an IF formula that tells me if their profile is complete (all questions answered, thus fields are filled) or not (one or several values in selected field missing).
There would be around 10 fields/questions (one in each column).

Any solution for this?

Thank you in advance

1 Reply 1

Hi @Pierre_Tillement - something like this:

IF(AND({Answer 1}, {Answer 2}, {Answer 3}), 'Profile Complete', 'Profile Incomplete')

Screenshot 2019-05-07 at 16.27.54.png

(Obviously, extend the formula for your 10 columns names)