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 . Such records would march either of the following criteria:
marked (manually) as non-actionable in a multiple-select field type
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.