Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Single select as Linked Lookup Field

Solved
Jump to Solution
1473 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Michelle_Fox
4 - Data Explorer
4 - Data Explorer

Hello!

I have two tables “Episodes” and “Team/Dates”. “Episodes” has a single select field called “Status” with 20 non-alphabetically listed options. When I create a linked lookup field in “Team/Dates” to the “Status” column in “Episodes”, it imports the field as text.

Is it possible to import it as a single-select field? Or to somehow retain the sorting order from the “Episodes” single select field?

The two workarounds I’ve found so far are adding a numerical prefix to each status (e.g., 01 Script, 02 Storyboards, 03 Edit) or using a formula in the second table with an emoji in front to do sorting.

Thank you!

1 Solution

Accepted Solutions
Aron
7 - App Architect
7 - App Architect

The formatting is indeed lost when you lookup a single select from another table and you’ve already figured out the solve I would recommend! Thanks for the feedback Michelle.

See Solution in Thread

1 Reply 1
Aron
7 - App Architect
7 - App Architect

The formatting is indeed lost when you lookup a single select from another table and you’ve already figured out the solve I would recommend! Thanks for the feedback Michelle.