Hey Boh, I have been using the "select data items" in the database worksheet, but I was hoping for a more efficient / elegant solution.
I've been brute forcing it using this technique, but I've some time and Id like to expand my skill set.
Here's my worksheet.
=DATABASE(INOBJECT & ((R IN ['Seat Data']) & ('Seat Data'.'Location'='UPPER ORCH 200')))
then summarized by column 2 ('Row')
I need to increment the ZCOORRDINATE by 190. I would expect a simple spreadsheet formula (=cell.above+190) to give me the desired result, but worksheets can only pull data, and I need to push it back to the objects. Does this require a script solution?