Hi there
I am trying to create a purchase order system to work with our Programme manager (which is all in Smartsheet)
Currently we use excel to create a purchase order then print it as a PDF. We then combine the PO with a quote from the supplier in Nitro.
What I am looking for is a way to use smartsheet such that we have a table of suppliers and when we input the suppliers name it automatically brings up their address and static details
How do I do that without using lotsoof nested if's and LOOKUP only seems to return a value so I would still need nested ifs to do it using LOOKUP
Help please
many thanks
