Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 12, 2023 12:45 PM
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
Solved! Go to Solution.
1 Solution
Accepted Solutions

Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 12, 2023 06:49 PM
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 2

Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 12, 2023 06:49 PM
Hi @Pjero_Kusijanov,
Is this formula not good?
IF(
AND(
{Fuel L}=BLANK(),
NOT(FIND("Fuel L",{CLEAR}))
),
CONCATENATE("• Add fuel tank", '\n')
)
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 13, 2023 11:57 AM
Hi @Sho ,
This does the job. I have simply forgotten that I can use NOT to reverse logic.
Thank you for your help 🙂
