I have ColumnA as an ENUMLIST column type with REF Base Type with four different option (values). I have ColumnB that returns the values not picked from the ENUMLIST. Them I have ColumnC with the Switch() function. Let’s say one of the values returned in ColumnB is “Upgrade” (not picked from ColumnA), I want ColumnC to switch it to “Needs Upgrade” , which is it does as long as ColumnB returns only one of the options from CoumnA. If ColumnB returns more than option (not picked from ColumnA) then the Switch () Function doesn’t work. Is there a workaround or what am I doing wrong??
Thank you.
Solved! Go to Solution.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |