Help

Complex Formula Question

Topic Labels: Formulas
791 4
cancel
Showing results for 
Search instead for 
Did you mean: 
RyanH
4 - Data Explorer
4 - Data Explorer

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
Ilan_Ben_Yaakov
6 - Interface Innovator
6 - Interface Innovator

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')

augmented
10 - Mercury
10 - Mercury

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'
)
RyanH
4 - Data Explorer
4 - Data Explorer

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