Hi,
I am having problem with a VLOOKUP process.
Our current process flow is as follows
Import data into a "DataDump" sheet through API, at this point each row of data is assigned a number, matching that of the row number (we do this so we can use an index match formula to pull data through to the secondary sheet we call "VLOOKUP"
At this point, the sheet "VLOOKUP" has a column with ascending numbers from 1 to 5000. We then have formula =index(match,match) / VLOOKUP pulling data through to this sheet from the "DataDump" sheet. This then creates a sister copy of raw data.
There are then calculations and check boxes completed to partially analyse this data in "VLOOKUP" sheet
A roll up sheet is then used to summarise this data from the "VLOOKUP" page, before formatted into graphs etc in a dashboard.
Now this sounds like a long process and i am happy to hear views on how we can streamline procedures, but it has been chopped and changed to accommodate a few things
1. Historic raw data can change - we therefore wipe all data from smartsheet and import again (this then takes account of changes to historical data, and updates added data.)
2. If we put calculations into the "DataDump" sheet, they are deleted when API removes all data - therefore we reference the raw data into a VLOOKUP sheet, essentially a secondary data dump.
We are aiming to put a timer on the data entry though the API so that it will update dashboards in real time.
However when we refresh the data into the "DataDump" Sheet we get the error on the "VLOOKUP" page - #NO MATCH
If I click into the cell then press enter, sometimes it will kick into life.
If I leave the sheet unopened however it does not kick into life.
We are aiming for nearly 50 VLOOKUP pages, and would like to be automatic in calculations
Thanks in advance
Steve