+2Multiselect 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
Best answer by Sho
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}, "([^,]*)$")
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}, "([^,]*)$")
+2Hi @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}, "([^,]*)$")
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
+23Hello @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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.