
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 07, 2024 01:27 PM - edited ‎Oct 07, 2024 01:35 PM
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
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 07, 2024 01:39 PM
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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 07, 2024 01:39 PM
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.
