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-sprin...
//
/////////////////////////////////////////////////////////////////////////
For more information about MultiTech Visions, visit
www.MultiTechVisions.com
#CitizenDeveloper #AppSheet