Python Script For Refresh Sheet

Hello Smartsheet Community,

I need to write a script in Python to refresh a sheet. In my sheet I am using the Today function to calculate the total net days from one specific date. I take that data and use it as a widget on my dashboard. Problem is, the widget doesn't update unless the I physically open the sheet.

Is there a way to write a script that doesn't need to use the webbrowser.open() function? Is there a way that I can link using the API and do some sort of boolean run through a column? I don't want to change anything in the sheet, I just need to reflect an open browser status or open sheet status so the Today() function will update appropriately.

My first pass was to do a webbrowser.open(sheet url link) then close it but I am having trouble finding the HTML code for the login page so I can automate the username/password. Any suggestions?

Thanks,

Veronica

Find more posts tagged with

API and Developers

Comments

dave-inden

Working in Smartsheet in your browser the formulas on a sheet are evaluated each time the sheet is loaded. You can simulate this to get the formulas to evaluate using the Smartsheet API. If a change is made to a sheet, including one via the API, the formulas on the sheet will all be run and any new values they calculate will be saved. So, if you can automate a script to make a request to a sheet and change any value on it the formulas will be run and the TODAY functions will update to the current date for your dashboard.

This can be done by making any change to a cell value on the sheet. You could insert a column that you keep hidden to use for this purpose. Then you can update a single cell in that sheet with a new value. Note, that if you send the same value over and over it won't work. The API will ignore any change when you provide the same value that is already found in the sheet. It needs to be a new value each time.

There is an SDK for the Smartsheet API for Python that you can find information on here:

https://github.com/smartsheet-platform/smartsheet-python-sdk

Usage of the Smartsheet API is all described in the API docs:

http://smartsheet-platform.github.io/api-docs/#

Sign in to join the conversation!

Quick Links

Trending discussions

Will and API token for a report give access to the Sheet the Report generated from?
Hi, I have a large Smartsheet, I want to generate a row report that reduces information displayed down to a specific group. For that Row Report, if I were to generate an API token and share it to a third party, will that third part have access to the information on the original 'Grid' sheet, or will it be reduced to what…
Smartsheet API Bug: Copy Sheet with include=forms Fails (Regression)
Hello Support Team, We are experiencing an issue with the Smartsheet Copy Sheet API when attempting to include forms. Endpoint: POST https://api.smartsheet.com/2.0/sheets/1097094865571716/copy?include=forms Request Body: { "destinationType": "folder", "destinationId": 608151415351172, "newName": "new_sheet_included_Forms"…
Issue with Searching a sheet with more than 10k rows
Hello, I am using the Smartsheet Search rows module in make : I am querying a sheet with 18k rows If i search for data in the first 10k rows it find is. if its after that, it doesnt find it. please help Kind Regards, Wesley.