Update a Single Status based across multiple fields

Hi all,

I currently use Airtable to do a series of date checks. I have about 15 of these per record, for various points along a user’s timeline:

IF(DATETIME_DIFF(TODAY(),{5d}, "days")>-1, IF({5d Email?},"✅", "❗"))

I’m looking to be able to create a Kanban view where I can see any record that has a❗ - indicating an outreach is needed - but this requires a single-status field in order to make this work.
Screen Shot 2021-06-11 at 10.44.32 AM

If I want to create a single-status field that automatically changes to “needs outreach” whenever there is a❗ emoji in any field in the record, is that something that’s possible to check easily?

Is there another, more elegant solution I am missing? Or am I out of luck?

Hey Sterling. You could use an automation do accomplish this. Trigger on the “:exclamation:” (OR’d across multiple fields), and update the record as the action. You would want another automation to set the single select back to empty (or whatever) if the record gets all check marks.