Hi all,
I have 2 sheets in my backend - Orders & Products .
My Product sheet has only 3 columns - Product Name, Country & Price.
In Orders sheet, Iโm storing the response of a form where I take โcountryโ and โproductโ as an input. Now based on this input, I want to get the price of the product for the input country.
Please help me to write an expression to get the price of the correct product. Please note that the price of a product is unique for a โcountry-productโ pair. A same product is of a different price in different countriesโฆ
I have already used Lookup & Select but not getting desired result. Kinldy help!
@Aleksi Please help.
Wrote this formula but not getting desired resultsโ
ANY(SELECT(Products[Price],CONCATENATE([Product - 1], โ:โ, [Country])=CONCATENATE([Product Name], โ:โ, [Country])))
Any(Select(Products[Price],AND(
[Product Name]=[_ThisRow].[Product Name],
[Country]=[_ThisRow].[Country])
))
To be used as the formula in Orders[Price]
Assumes you have Orders[Product Name] and Orders[Country]
Also check out - https://help.appsheet.com/en/articles/961554-dependent-dropdown
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |