Comparing List with List | AppSheet Explained

In this video I show how you can compare two lists with each other, finding the common elements, to use as a logical filter statement (which could then be used in a slice or security filter, for example). BASIC IDEA: - First use INTERSECT() to find the common elements between two lists - Then us IsNotBlank() to determine if that resultant list is NOT empty - IsNotBlank(Intersect([LIST_1], [LIST_2])) If there are common elements, then the INTERSECT() will result in a list of those common elements; and by wrapping that in IsNotBlank() I can get a logical statement to use in other formulas. Table of Contents |---------------------------------------------------------------------------------------- COMMING_SOON (someone help me out here...) ----------------------------------------------------------------------------------------------------------------------- ///////////////////////////////////////////////////////////////////////////// /// SUPPORT THE CHANNEL ///////////////////////////////////////////////////////////////////////////// // // Answer Portal // https://www.MultiTechVisions.com/answers // // Merch // https://multitech-merch.creator-spring.com/ // ///////////////////////////////////////////////////////////////////////// For more information about MultiTech Visions, visit www.MultiTechVisions.com #CitizenDeveloper #AppSheet