How do I populate one field fromt he results of another

vbtudor

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

 

 

Chris McKay

Hi vbtudor,

Are your static supplier details in another sheet?

J. Craig Williams

How many static details (which I assume are columns) do you have?

Craig