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
Sep 12, 2022 09:24 AM
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!
Sep 12, 2022 07:45 PM
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