Pull data from excel and update Smartsheet

AML

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.

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!