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

Complex Formula Question

Topic Labels: Formulas
213 4
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi everyone! This is my first post in the Airtable community, and I have quite the ask.

I need to create a formula that is able to look across four different fields in the same table, and check if those fields have one of two particular values (Let’s say the possible values are ‘Complete’ and ‘None’). If all four fields have either ‘Complete’ or ‘None’ at the same time in the same row, I want the formula to print ‘Yes’. If any of the four fields have a value other than ‘Complete’ or ‘None’, then the formula should NOT print ‘Yes’.

I have tried using a combination of IF, OR, & AND statements, but this has proven to be quite the formula, and I am not the most experienced coder.

My reason for this request is that I want to be able to filter off the value this formula creates, that way I can see all of the tasks in my base that are in progress.

I hope this makes sense, any input is appreciated!!!

4 Replies 4

that should work:

IF(
  AND(
    {condition 1}="Complete",
    {condition 2}="Complete",
    {condition 3}="Complete",
    {condition 4}="Complete"),
  "YES"
)

Hi,
use something like
Concatenate(field1,field2,field3,field4)
to debug,
then
if(Concatenate(field1,field2,field3,field4)=rept('Complete',4),'Yes')

Hi Ryan. Maybe something like this…

IF(
  OR(
     AND(
       {field1}='Complete',
       {field2}='Complete',
       {field3}='Complete',
       {field4}='Complete'),
     AND(
       {field1}='None',
       {field2}='None',
       {field3}='None',
       {field4}='None')
  ),
  'Yes'
)

Thank you all for your replies! Through your ideas, I was able to find the solution!!!