IF formula for missing fields

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

Hi @Pierre_Tillement - something like this:

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

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

JB

2 Likes