Formula or setup help

FIRAT_BAYRAM_BA · ‎Sep 12, 2022

Hello, I have a simple question:

I want to insert tags automatically when a cell or multiple cells contain value under, or above a level or contain certain words on a different cell.

For example: if value is below 50%, insert tag(multi-select) “Low traffic”
or if the “Health Care” word is present in a cell, then insert the same multi-select tag cell “Animation”

Basically I want to auto tag my data. Do I have to create an automation for each tag?

Thanks!

Adam_TheTimeSav · ‎Sep 12, 2022

Nah. I think if I were you I’d have a formula field set up that would output text, and then I’d have a single automation that would paste the value of the formula field into the multiple select field

With reference to your examples above, I’d have:

IF(
  {value} < 50,
  "Low traffic,"
) & 
IF( 
  FIND(
    "Health Care",
    {Cell}
  ),
  "Animation,"
)

And so it’d output “Low Traffic, Animation,” if it met the criteria you’ve set above, and then the automation would paste it into the multiple select field