Help

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

Topic Labels: Formulas
Solved
Jump to Solution
764 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Mary_Usen
4 - Data Explorer
4 - Data Explorer

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

1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

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}, "([^,]*)$")

 

See Solution in Thread

3 Replies 3
Sho
11 - Venus
11 - Venus

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
5 - Automation Enthusiast
5 - Automation Enthusiast

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 

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.