How to find blank values or empty cells in a multiselect type column

#1

How to find blank values or empty cells in a multiselect type column?

0 Likes

#2

Use $mxcnt 0, that is search for records where max count of values in a multiselect cell is 0. This will result in all the blank or empty cells in multiselect type column

Example - LOOKUP([BaseSheet.unique_id],BaseSheet.skills $mxcnt 0)

0 Likes