This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
HI There, I'm trying set "Value Of" expression, for dependent dropdown.
All columns are work just fine except one ref column. From ref column
all values returns as a one string separated by comma.
hello everyone. I have a different sheets connected each other with
references. I need to bring some values from some columns in reference
sheets to one cell in main sheet in every row. I Concatenate(), but its
brings all column volues ensted of rows...
Last column in the source table is REF,and result in main table (where
Valid if expression "Branches[Related TERMINAL PARKs]") ilike in
screenshot below. but should be different rows, instead of separated by
commasorry for my english, I know its not ...
Thank you for answer Language is Armenian
.SPLIT(TEXT(SELECT(Branches[Related Terminal Park],
[Branches]=[_THISROW].[ ]))," , ")This one also not working. Rest
columns are working just fine, only last column is problem