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?