Sign in to join the conversation:
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?
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
That is one way of doing this. I was wondering if there is any other way as well.
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.
That sounds like the way I will have to do this. Thank you so much.
Hey, I am using the below formula→ =INDEX({Source_Sheet_Entire_Table}, MATCH([Unique ID]@row , {Source_Sheet_ID_Column}, 0), 1) Although the answer should be "Project details" mentioned in Column 1, it says #No Match. What am I doing wrong?
I have inly one user in my trial account. When I am trying to upgrade to PRO plan it is defaulting for 2 users and not allowing me to upgrade the plan for only one user. Please help.
How can I delete old sheets I no longer use from my account?