Dynamic Action from Row
I would like to apply a dynamic condition on a view from a sheets row. TableA: ID,Name,Address,Date TableB: Name,Filter Action: LINKTOFILTEREDVIEW(“TableA”, [Filter]) TableB lists Name,Filter rows to be applied by the row action. A filter use-case (atm) is to apply an address zip or date match. So, if I wanted to apply a filteredview on [Address]=[Filter] where Filter="[Zip]=77777" (address is actually separated columns; address,state,zip) how would I pull the contents into the expression without the expression failing on validation for a boolean return? Or is another method better, using SELECT() in Action expression… I would like to populate the Filter column with either numbers (as a zip) or dates and have the expression evaluate for only zips or only addresses.
Filter: “111111” “8/10/2001” “{11111,22222}” Or “[Zip]=11111” “[Date]>TODAY()” “[Zip]={11111,22222}”
LinkedIn
Twitter
