Hi. Is there a way (expression) for Appsheet to pick the first value (Row 2) in Google sheet and assign the value to the column?
For example,
Product name (Table) Name (Column in Appsheet): AAA (get the first value in Product name table)
Solved! Go to Solution.
LOOKUP(
MIN(Product table[_ROWNUMBER]),
"Product table",
"_ROWNUMBER",
"Product name"
)
User | Count |
---|---|
17 | |
11 | |
7 | |
5 | |
5 |