Creating an automatic Change Order

justin46491

I was wondering if there is a way to create a change order in a smartsheet so we do not have the type everything out and it will auto populate pricing?

 

 

Mick Jordan

Hi Justin, are you thinking along the lines of eg typing in a product code and Smartsheet then automatically showing the pricing and other standard info available with the product?

Mick

 

justin46491

That is one way of doing this.  I was wondering if there is any other way as well. 

Mick Jordan

ok what I do for a similar scenario is to simply use VLookup formulas to other sheet/s to bring back the info needed for the costs to be shown or further calculated.   We use it in a similar manner for a resource pool of labor costs against named resources.

Mick  

justin46491

That sounds like the way I will have to do this.  Thank you so much.