Your formula is missing a right parenthesis after the digit 2 (which means that my original formula in this thread is also missing that parenthesis! I'm correcting the formula above)
If you are on a higher-tiered plan, you could certainly use a script action to combine the fields, ignoring blank ones.Here's an alternative approach that doesn't require scripts that seems to work:Clear out the current values in merged multi-select ...
Hi @tsallis,What's happening is that the automation merges the values from both trigger columns even if one of those columns is empty. To avoid those empty values, you could change the original automation to use several Conditional Actions instead of...
Was trying to give @kuovonne's reply a Kudo but apparently that isn't possible anymore? Or, poking around a bit, maybe it's only possible in certain categories? Anyways, since there isn't another way to express agreement with that reply, here's one:+...