You're welcome, happy to help!I actually love using show as 'view' for linked records. It gives you so much possibilities for new workflows within record details pages. Have a nice weekend!
Hey there! I would suggest to choose show as 'view' instead of 'field'. This way you can sort the way you want and you can also choose to not show the primary field. Hope this helps. All the best,
Here’s a formula that accomplishes your requirements. Make sure to replace {YourField} with the actual name of your field containing the strings. UPPER(
LEFT(
REGEX_REPLACE(
REGEX_EXTRACT({YourField}, '^(\\w+)[^\\w]*(\\w+)')...
Sometimes, re-creating the groups can refresh the sorting behavior. Delete the existing groups and create them again in the desired order, does that work? Or if this still doesn't work, consider creating a new view with a simpler structure for testin...