Help

If value is not find in multiple select field

Topic Labels: Formulas
Solved
Jump to Solution
982 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Pjero_Kusijanov
7 - App Architect
7 - App Architect

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
1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

Hi @Pjero_Kusijanov,

Is this formula not good?

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

See Solution in Thread

2 Replies 2
Sho
11 - Venus
11 - Venus

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 🙂