Skip to main content
Solved

If value is not find in multiple select field

  • September 12, 2023
  • 2 replies
  • 45 views
P
Forum|alt.badge.img+10

Hi 🙂

I have a formula field "TASK" that checks if there is value in fields or not.  It looks like this;

IF({Fuel L}=BLANK(),CONCATENATE("• Add fuel tank", '\n'))
 
Now, I want to have another multiple-select "CLEAR" field that clears the TASK value if the corresponding value is included in multiple select fields.
 
For example {Fuel L} is blank, but in the CLEAR field "Fuel L" is selected. This setting should not show   "• Add fuel tank" in TASK field.
 
I tried with FIND(), but I should use something as not FIND()...
 
I would appreciate help to accomplish this.
 
Thank you,
Pjero

Best answer by Sho

Hi @Pjero_Kusijanov,

Is this formula not good?

IF( AND( {Fuel L}=BLANK(), NOT(FIND("Fuel L",{CLEAR})) ), CONCATENATE("• Add fuel tank", '\n') )

2 replies

S
Forum|alt.badge.img+21
  • Sho
  • Inspiring
  • Answer
  • September 13, 2023

Hi @Pjero_Kusijanov,

Is this formula not good?

IF( AND( {Fuel L}=BLANK(), NOT(FIND("Fuel L",{CLEAR})) ), CONCATENATE("• Add fuel tank", '\n') )
P
Forum|alt.badge.img+10
  • Pjero_Kusijanov
  • Author
  • Known Participant
  • September 13, 2023

Hi @Pjero_Kusijanov,

Is this formula not good?

IF( AND( {Fuel L}=BLANK(), NOT(FIND("Fuel L",{CLEAR})) ), CONCATENATE("• Add fuel tank", '\n') )

Hi @Sho ,

This does the job. I have simply forgotten that I can use NOT to reverse logic.

Thank you for your help 🙂

 

Terms & ConditionsAccessibility statement