Formula to Assign Single-Select Value

[M_L]

Hello,

I'm moving into the List View Interface, and I am loving the "Prefix" field which allows me to use visual indicators to quickly see the status of records. My current roadblock is this, I haven't been able to figure out:

How can I have a Single Select Field automatically assigned based on a formula?

As shown in the screenshots below I have:

1) Created a Single Select field that has a "Stoplight Anaylsis" of a record's status as Red, Yellow, or Green.

2) I added this Single Select field as the "Prefix" in my List View Interface

3) Now I want to know how to automatically assign the status based on other fields. Specifically:

• GREEN if {Leader} and {Client} are filled
• YELLOW if {Leader} AND/OR {Client} are empty
• RED if {Leader} AND/OR {Client} are empty AND the date is in the Past.

It's not a difficult concept, just trying to see how to implement it in Airtable.

Quick Update 10/7 4:35pm EST:

* I was able to generate the emojis using a formula, BUT formula fields are not available for me to use as a Prefix. So I'm back to the question, how do I get these formula results into a Single Select Field so I can make it my List View Interface prefix?

TIA,

ML

[M_L · Accepted solution]

Apparently, the solution to my problem was rolled out 4 months ago here. Hooray!

I added the link for anyone else looking for it on the forum like me.