Grouping folders

[Jeff_Hager]

Unique List

Here is a technique that I learned from @Jeff_Hager. You will need a RowID column in your sheet. Create a self-relation linking the company name to itself. This should be a single relation (call this rel-self) Create a Lookup column to fetch the RowID from that relation (call this lk-unique-id) Finally, create an if-then-else column: If RowId is lk-unique-id, then true. Else blank. (call this ite-is-unique) You can now use this last column to filter your Inline List: “where ite-is-unique is t…