Formula field that searches a multiple select field and returns the last entry.

[Mary_Usen]

Multiselect Field: Sprint
contains
row 1: Sprint 24.01, Sprint 24.02, Sprint 24.04
row 2: Sprint 24.04, Sprint 24.05, Sprint 24.06
row 3: Sprint 24.03

want a formula in new field called "Latest Sprint" to return the last entry in the Sprint field

row 1: Sprint 24.04
row 2: Sprint 24.06
row 3: sprint 24.03

thanks for any help!

-Mary

[Sho · Accepted solution]

Hi @Mary_Usen,

The multi-select field is just a text string in the formula field, so it cannot be calculated.
It is possible to extract only the last select as a text string.

REGEX_EXTRACT({Multi Select}, "([^,]*)$")

[mku901]

Thank you so much @Sho ! Very helpful!!!   This worked! But then uncovered that when the data maps over from jira makes the multi select field not populate in sequence.   But that’s a me problem!  Your formula was excellent! Thank you so much 

[dilipborad]

Hello @Mary_Usen & @mku901 
If this formula helps and fixes your problem then please mark the @Sho post as the solution.

It helps others to identify how this is done and also helps more creators to help other people.