Trying to get the “)” to display after the “X” in COMX
(({SchDep} & “-”) & {Dest} & “-”) & {LdTo} & " (" & {SCAC} results in:
2200-KLO-KLO (COMX
but
(({SchDep} & “-”) & {Dest} & “-”) & {LdTo} & " (" & {SCAC} & “)”)
results in a formula error.
I’m als...
Trying to achieve an outcome where:
IF Column One is prefixed 381 then Apple
If column one is prefixed 382 then orange
etc
Column 1
381-9287
382-2818
383-2812
Column 2
formula
Thanks!
Cool, thanks!
How would I incorporate SWITCH(LEFT({Column 1}, 2), ‘5v’, ‘Blue’, ) and SWITCH(LEFT({Column 1}, 4), ‘123a’, 'Metal;) into the same formula as the one you wrote out above?
