Creating an automatic Change Order

justin46491 · 06/19/18

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 · 06/19/18

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 · 06/19/18

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

Mick Jordan · 06/19/18

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 · 06/19/18

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

Creating an automatic Change Order

Comments

Categories