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.
Hi,
I want to create a field that will change based on the results of a single select field.
For example, my single select options are [1, 2, 3, 4]. In another field I want to report options [A, B, C, D]. I want to choose A if the next column is 1, B...
Thanks! I tried this with a single entry and it worked, however when I scaled it up I get an error message and am told that its not a valid formula.
This is what I entered.
SWITCH( {Umbrella Elective}, “Discovering the Arts (for 1 elective)”, 100, “...