We are trialling smartsheet and overall enjoying it so far however we have run into a bit of brick wall and any help would be appreciated!
We have a main sheet with all our orders on it, using an older version to muck about with layout at set up at this stage hence the old haulage dates! Each order has details of the sizes etc and then on the right hand side (not seen in the screenshot) are customer details for admin processing. What we want to do is be able to have a row at the top of the sheet where we can type in an order number and the basic order details (quantity, size, thickness, category etc) will populate the top row of it's column so we can get a quick overview of the production of the order.
We have been trying vlookup and index functions but obviously doing something wrong as it's not working. This is just the start of something bigger but we are falling at the first hurdle so any help would be greatly appreciated.
Thanks in advance.
Help Article Resources
Check out the Formula Handbook template!