Hi, I have two table in my appsheet, the first table has the column of Room is ordered, it value is ref type which references to the second table which has the column of Room List (Enum type). I want to compare two table and show me which room isnโt being ordered.
Solved! Go to Solution.
There is nothing correct with that expression. I STRONGLY encourage you to spend more time reading the available documentation on expressions.
Please take a look at
I tried this function in Valid if: ({SELECT(Table 1[Room list])} - {SELECT(Table 2[Room is ordered ])})
And it showed โ LIST has elements of mismatched types appsheetโ
Room is orderd column value (Ref type) is ref of Room list column value (Text type)
I donโt know what is the problem. Please help me out. Thanks!
There is nothing correct with that expression. I STRONGLY encourage you to spend more time reading the available documentation on expressions.
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |