Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Formula or setup help

Topic Labels: Automations
119 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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!

1 Reply 1

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