-
SSL certificate issue
Our code throws and exception when trying to call Smartsheet API: SSL Exception: error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed The Rest Client has a logic to verify certificate using the windows system certificate store . It looks to me the CA certificate for Smarthsheet API is not…
-
Automatically Add recent changes information to a row.
Hello, I'm trying to look If there is an option to automatically update the changes happened in the worksheet from past 10 days in to new column (Lets assume the column name is "History_Past10Days") Information I'm looking in this column(History_Past10Days): All the column Names updated from past 10 days Ex: Sheet has 20…
-
Graphs from Excel into Smartsheet
Is there a way to take a graph that was created in Excel and import it into a Smartsheet? I can do it via a dashboard but I would like to have it directly on the sheet with the data.
-
How do I pull data using Reports API from 10000ft into Power BI
Hi, I am trying to import data from the 10000ft reports using the following API link, but I get the message 'Not Found'. https://api.10000ft.com/api/v1/reports/rows?view=time_fees_hours&time_frame=this_week&auth=<URL-ENCODED-TOKEN> Can anybody help? Thanks
-
Export Smartsheet attachments to OneDrive
Hi! I'm using Smartsheet to gather information through forms. People fill in a form, they add a picture in the submission, and all this gets saved in a sheet. Eventually, I receive rows filled with information in Smartsheet and for each row there is a picture attached. I need these pictures not only within Smartsheet, but…
-
Lead Tracking In Smartsheet
I need to be able to track leads sources in Smartsheet. There is currently no ability to passthrough the URL of the embedded page for UTM parameters. None of the options for fields support scripts to manually pull that URL for example; <script> document.getElementById("demo").innerHTML = "The full URL of this page is:<br>"…
-
Can I create a report/Sheet that would capture all conversations on multiple sheets in a workspace?
I have multiple sheets(Representing a job) in a workspace that have conversations. I am wanting to combine all of the conversations into one report or sheet to see all of them in one sheet. Can this be done?
-
Email (Outlook 365) into Smartsheet
I'd like emails that arrive in an Outlook 365 inbox to be added as a row in Smartsheet. What's the best way to do this?
-
Smartsheet webhook subscope weird behavior
I have a sheet on smartsheet that looks like this: I wish that when `test_trigger` column in the sheet got changed, smartsheet can send a notification to my AWS API gateway. So I use webhook with subscope to setup the notification. However, I can't tell which cell in `test_trigger` column got changed from the request sent…
