Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

IF formula for missing fields

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

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)

JB