I need help with an expression.
I have a timesheet, and I would like to figure out the total cost of the plants.
I have columns where the plant size is selected by the crew in a form, and then a separate column with that item’s quantity.
I would like appsheet to use the value of that column [Plant Size (1)] to look up what the equivalent price is, located in another spreadsheet.
The Column [Plant Size (1)] is an Enum list right now.
But equivalent place sizes and their prices are listed in this other spreadsheet.
Nothing is a key in either spreadsheet.
My problem with using the LOOKUP expression is that it requires me to lookup a specific text value, but I want to refer it to the value of that column in the same row.
How do I do this? Thanks! Miranda