Forum Discussion

AmberPolston's avatar
AmberPolston
Qrew Cadet
4 years ago

How to use a text field to populate the field names in a formula field

Is there a way to use the values from a text field ([Text Field) as the "field name" in a formula field. The text field is populated by a formula converting a [Multi-Select Lookup] field into a for...
Formulas and functions
AustinK's avatar
AustinK
Qrew Commander
4 years ago
What is the use case for building it from the text field in this process? Maybe if that were explained it would be easier to understand what is happening here in your process and why so someone could help you.

To me it seems like you should use the Multi-Select Lookup field in your formula and extract what is in there each time with a variable or similar. But I think knowing the use case might help.