Pull data from excel and update Smartsheet

Hi everyone..

I am new to the community..so hopefully my question is not too stupid

I am currently using Excel to calculate a value by using the normal distribution formula. I would like to pull this value from excel and then update a cell in Smartsheet. It is an on-going exercise so the fetch should be done regularly (ideally real-time). May I know which is the best way to achieve this? Data uploader? Data connector?

Thank you.

Find more posts tagged with

Marketing

Importing and Exporting

Cell linking

Comments

Andrée Starå

Hi,

Welcome to the community!

Is it just one cell?

It sounds to me that Zapier would be an excellent option for this scenario. Is that an option for you?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

AML

hello Andrée!

Thank you for your prompt response. It will be multiple cells..for every row..

My objective is to get around the fact that Smartsheet doesn't support 'Normal Distribution', my idea is like below:

1. Whenever user updates column A in Smartsheet

2. It triggers to copy and paste the row in excel with the value from Smartsheet.

3. Excel calculates the required value based on the Smartsheet values by using Normal Distribution formula

3. Smartsheet pulls the calculated data from Excel and update column C on Smartsheet

Am I over-complicating the whole setting? haha

Andrée Starå

Happy to help!

No, I don't think you're over-complicating it because it's something that you need.

I think it would be possible to set it up with the help of Zapier or similar.

Would that work?

AML

Thank you very much for your confirmation.

I will take a look at Zapier

Andrée Starå

Happy to help!

Let me know how it goes!

Have a fantastic weekend!

Sign in to join the conversation!

Quick Links

Trending discussions

SUmmary in Report Widget
How can i create a Report widget that only shows a status with "red status" from my main data source? Do i need to create a separate data source on just my "red status"
Folder Level Sharing
Circling back to this….. Another year goes by and still no folder level sharing. Smartsheet developers don't listen to their clients. I have seen hundreds or posts and requests for this over the past 7-8 years. And still NOTHING!! This has been a huge issue for us as a company. As you can tell this is a sore spot for us…
Restore multiple cell changes from Snapshot
Today a team member accidentally changed several rows by either deleting the data or the row itself. Do I download a snapshot of each one to restore? Some of them didn't seem to be too helpful. What is the protocol for restoring this information? I've only done this before with the help of a representative and it was…