Skip to main content

Complex Formula Question

  • August 25, 2022
  • 4 replies
  • 42 views
R
Forum|alt.badge.img+2

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

I
Forum|alt.badge.img+7
  • Ilan_Ben_Yaakov
  • Participating Frequently
  • August 25, 2022

that should work:

IF(
  AND(
    {condition 1}="Complete",
    {condition 2}="Complete",
    {condition 3}="Complete",
    {condition 4}="Complete"),
  "YES"
)
Alexey_Gusev
Forum|alt.badge.img+25

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

TheTimeSavingCo
A
Forum|alt.badge.img+18
  • augmented
  • Inspiring
  • August 25, 2022

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'
)
R
Forum|alt.badge.img+2
  • RyanH
  • Author
  • New Participant
  • August 29, 2022

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

Terms & ConditionsAccessibility statement