Hey there! I have a saved search formula puzzle. My company has an API integration that exports items from NetSuite to our website, including display names, pricing, and other fields, and the information is compiled in the form of a Saved Search. We recently added a German website, so everything that has copy now needs a translated version as well. For things like the Display Name, I was able to pull it in using this formula: • Field: Formula (Text) • Summary Type: Maximum • Formula:

CASE WHEN {language} = 'German' THEN {displaynametranslated} ELSE NULL END

• Summary Label:

German Display Name

However, we have certain fields that are List/Record fields, and we found that the values of a Custom List can have translations (see screenshot). Is there any way to pull these translations into a Saved Item Search using the same or similar techniques as the field above? If not, we are considering converting the Custom Lists that are affected into Custom Records, and creating translations as separate fields (instead of utilizing these native translation fields) since custom records can be joined into a Saved Search. But it would be cleaner if we can avoid creating new fields for each translation, and converting things into custom records. Thanks for your time, I really appreciate everyone here!