Skip to main content
Solved

Checkbox formula involving two field types

  • May 11, 2020
  • 5 replies
  • 47 views
M
Forum|alt.badge.img+3

Hello,

I have a database that is updated live (through an integration), but some records can go directly to archive (via a filter). I am trying to build a formula that will identify as many archivable records as possible and mark them with :white_check_mark: . Such records would march either of the following criteria:

marked (manually) as non-actionable in a multiple-select field type

OR

contain a certain word in a single line field (e.g., if a single-line cell contains ‘no-reply’ => archive)

I already have a formula for the former, but I wonder if a formula that would combine both is possible to build.

Best answer by kuovonne

Yes, it is possible to combine the conditions in a single formula.
You want the OR formula function.

It would look something like this:

IF(
  OR(
    FIND("non-actionable", {multiple-select field}),
    FIND("no-reply", {single line text})
  ),
  "✅"
)

5 replies

kuovonne
Forum|alt.badge.img+29
  • kuovonne
  • Brainy
  • Answer
  • May 11, 2020

Yes, it is possible to combine the conditions in a single formula.
You want the OR formula function.

It would look something like this:

IF(
  OR(
    FIND("non-actionable", {multiple-select field}),
    FIND("no-reply", {single line text})
  ),
  "✅"
)
M
Forum|alt.badge.img+3

Yes, it is possible to combine the conditions in a single formula.
You want the OR formula function.

It would look something like this:

IF(
  OR(
    FIND("non-actionable", {multiple-select field}),
    FIND("no-reply", {single line text})
  ),
  "✅"
)

Hmm, that didn’t work for me, unfortunately, though I made sure the formula is formatted correctly. Any suggestions as to why it is not working?

kuovonne
Forum|alt.badge.img+29
  • kuovonne
  • Brainy
  • May 14, 2020

I had an extra comma in the formula. I edited the formula to remove the extra comma. Try it now. If it still doesn’t work, please post a screen shot.

M
Forum|alt.badge.img+3

It worked. Many thanks!

Justin_Barrett
Forum|alt.badge.img+21

It worked. Many thanks!


Glad to know that you got the answer you were seeking, @Marina_Malazoniya ! If you would, please mark the appropriate comment as the solution to your question. This helps others who may be searching with similar questions. Thanks!

M
Terms & ConditionsAccessibility statement