How to retrieve a cells data when the cell doesn’t exist yet
Hi There .
Maybe not possible but hoping for some advice.
We have an order input sheet. this has a transaction id column that automatically assigns a number. When this number is assigned the details are moved to a holding sheet.
My idea is this
I would like the ability for different departments to have their own sheet when working with this order. For example that picking is the first to get it using index match of the transaction id and add more data ,The holding sheet also has index formulas to bring that data back so an orders info is all on the same row. and so on.
My problem is i’m not sure how to have the picking sheet reference a transaction id that doesn’t exist yet. EG if the order sheet is creating the id how can i create formula that grabs the next id when it’s created?
the reason i’m doing this is to try to avoid the moving or copying of rows as this brings across lots of columns that are not relevant for various departments, im also trying to use card view to simply the look of the data and even though rows are hidden they still show up in card view.
Sorry if im not making my self clear
If you have questions fire away.
Thanks in advance
Help Article Resources
Check out the Formula Handbook template!