Single Select Outputs for Formula fields

Can you provide a screenshot of the issue please? 

Bonjour et merci voici le résultat (pièce jointe) et la formule utilisée

Bien cordialement 

IF(
{Mardi Activité Matin*},
DATETIME_FORMAT({Jour 3}, 'DD/MM/YY')
& " " & Mardi
& " - " & {Désignation Abrégé copy}
& " - " & {Mardi Activité Matin*}
& " - RDV : " & {Heure Rdv Mardi Matin*}
& " - Panneau : " & {Lieu RDV Mardi Matin*},
BLANK()
)

Thanks for the screenshot and the formula!  Hmm, could I confirm that in your formula field, you've created one option per possible outcome of the formula?

In the following screenshot, you can see that the second record does not display an option as I did not create a select option of "06/06/24 Mardi - Désignation Abrégé copy"

Hello and thank you for your feedback, I think that what I want to do is not in line with the formula

The formula for my field concatenates several results from several fields. I would like to color the "single selection" field = {Tuesday Morning Activity*}, this field has several possibilities: Mountaineering, climbing, hiking.... so it is one of these outings that I would like to color
IF(
{Tuesday Morning Activity*},
DATETIME_FORMAT({Day 3}, 'DD/MM/YY')
& " " & Tuesday = 06/17/24
& " - " & {Abbreviated designation copy} = PBS Mt Blanc
& " - " & {Tuesday Morning Activity*} = Day hike or climbing, or mountaineering or trail....
& " - Appointment: " & {Meeting time Tuesday Morning*}
& " - Sign: " & {Meeting location Tuesday Morning*},
BLANK()
)

The information that results from the formula
06/17/24 - PBS Mt Blanc - Day hike - Meeting: - Sign: , 06/17/24 - Brek PBS - Day hike - Meeting: - Sign:

Merci

Hmm, the formula field will only output single select options for options you've manually created, and so you will need to create one option per variation of the formula output

For example, if you have a formula that outputs "A", "B", "C", you must set up your formula field's select field options like this:

If not it will just display as "Default".  For example, if I make the formula field now output the text "D", it will show the option "Default" instead, does that make sense? 

Bonjour et merci, voici un lien vers d'une vue où j'ai reproduis ma problématique

sur les deux dernièrs champs de formule l'un est avec la mise en forme le second sans mise en forme 

champs "Calcul et mise en forme" avec le résultat avec mise en forme 

champs "Calcul sans mise en forme" avec  le resultat de la formule 

https://airtable.com/appYGvpIAdS7m5Hab/shrX4X3SSqiDnYRkU

Pour moi le réslutat que je recherche c'est :

bonne jounée

Yeap, it's because you did not create each possible output as an option in the single select field.  Once it's set up like this:

It'll look like this:

Link to base

Merci pour votre réponse cela est compliqué à mettre en place

Yeah, I don't think they expect it to be used with very dynamic formula outputs I'm afraid

Can I add a follow-up to this? 
 

Does anyone know a workaround to the limitation of having to create every possible output in order for the formula field formatted as single-select to display properly? I’ve got a formula field that outputs a year (Say, “2025”) based on a date field. I’ve pre-filled the year options for a number of years going forward, but I’d love to not have to keep manually adding more years, and am worried my clients won’t know to add new options when it suddenly starts displaying a blank field. 

Unfortunately, there is no workaround for that.

But what you could do is setup an automation that “copies and pastes” the formula’s result into a normal single-select field, and use the single-select field instead of the formula field.

New values are automatically added into single-select fields, so that would solve your problem.

Hope this helps!

If you have a budget and you’d like to hire the best Airtable consultant to help you with this or anything else that is Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Hey ​@annebocc, I struggle with that every single time. So I feel the pain of having to do that manually.

It would be great if you could submit such product idea by filling out this Feature Request/Product Idea form.

In the meantime, Scott’s solution should def work!

Mike, Consultant @ Automatic Nation 

Thanks, ​@ScottWorld and ​@Mike_AutomaticN ! I did try Scott’s solution and it works great (turns out I had already done something similar in another part of my base, and forgotten about it, haha). Appreciate the help!

Glad to hear that ​@annebocc!

Feel free to reach out as needed :D

Mike, Consultant @ Automatic Nation