I need a formula to check if there is exact matching for multiple select field when values can have comma. Here is a sample multiple select I can have:abca,bI need to check if users selection is exactly 'c' and 'a,b'. All solutions I found (like usin...
I have a table with Rating field which can have value up to 7.
With current API I can get value for each record, but I can’t get metadata for that field, to know possible max value.
Is it possible at all?
@Sho you are right, this is not exact matching. Your version was correct, I just had typo on my side. Will do some more tests and will accept as solution.
I removed LEN and looks like it works, will try some corner cases and will update here.Here is formula I am trying IF(
AND(
REGEX_MATCH("##"®EX_REPLACE({select},", ","##")&"##","##c##"),
REGEX_MATCH("##"®EX_REPLACE({select},", ","##")...
Of course I tried it.Let me explain more visual way.This is my multiple select:You can see there are 4 options.This is selection I want to check:Hope this is more accurate description.
Thanks for response @Sho , but this will not work, as in my case 2 of 4 items can be selected (or 1, or 3, or all 4) and LEN({select})=LEN('"a,b", c')will not be true, as for this sample {select} is 'a,b,c,"a,b"'
