Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

If value is not find in multiple select field

Topic Labels: Formulas
Solved
Jump to Solution
1323 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 🙂