Updating sheet data

pcpatter

Ive got a smartsheet im setting up for inventory management. Fairly new to smartsheet but have a handle on the basics. My question is this:

Lets say once a month several vendors send me their inventory update in an excel. Is there some way to automate adjusting the values in the sheet? all the info in a row would be fixed and just the qty on hand field needs updated. There may sometimes be entirely new rows as well.

Kelly Moore

Hey @pcpatter

What type of license do you have - that is, do you have access to DataShuttle? DataShuttle, a smartsheet premier app, is made to do exactly what you are asking. It will allow straight-forward upload from excel to smartsheet.

Kelly

pcpatter

We have business licenses. Does that include data shuttle or is it a separate fee?

Kelly Moore

@pcpatter

Here is info on DataShuttle. It appears to be included in a business license.

https://help.smartsheet.com/learning-track/integrations-and-add-ons/data-shuttle

Kelly

Genevieve P.

Hiya! Just jumping in here to clarify, Data Shuttle is an additional purchase that may or may not be included with a Business plan, depending on your specific account and plan.

Here's more information on the Pricing page: https://www.smartsheet.com/pricing

Cheers,

Genevieve