Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Question about creating a pricing sheet with multiple linked sheets
New to SmartSheet and have only been through the basic training video. I understand this product is super powerful and can do just about anything related to spreadsheets. I just wanted to reach out to the community to see if what I was looking to accomplish is something the group feels is obtainable before I keep diving into further training.
We are a food wholesale company and we have a master price list we maintain currently in excel. From the master list we create 4 (linked to the master) sheets with the identical products except at different price levels created via a formula.
In addition to this we would like to create 25-30 (linked to the master) sheets that would contain specialzed pricing or bid sheets for larger clients that would not have our full product offerings but instead a limited selection of products from the master price list. I saw in the training video that you can setup automatic distribution of certain sheets , so the plan would be to update the master price list every morning and then have these 25-30 specialized sheets update and automatically email out to our clients.
Sorry for the long winded question and thanks in advance for any help with this!