Hello everyone, I have two files "request" and "price"google sheets. In the "behavior/action" of my AppSheet I want to insert Expression
ANY(Select(Price[Price], AND(IN([Boiler type],Price list[_thisrow].[Boiler]), IN([Required works], Price list[Type of work]), TRUE)))
But it always outputs only the first line, how do I get the corresponding [Price] from the two fields [Boiler] and [Required works]?
LinkedIn
Twitter
