-
Automatically creating new columns when import data from API
When using API to fetch data from other platforms and import into SmartSheet, how to automatically create new columns, if there are more columns in the data than the target sheet on SmartSheet (right now, importing data from API to SmartSheet need to specify column ID, but when we have a dataset with many columns, this…
-
How to create permanent API key after authenticate by OAuth2
From GUI smartsheet, I can generate an API key for Rest API. But I need to build an application that authenticate user by OAuth2, then can generate a permanent API key. In my context, there is an external application call the smartsheet API with the api key that is generated at time user authenticate via OAuth2.
-
Is there a way to grab attachments from a new line in smartsheet and merge it with the print file
Hi, I have been trying to work on a system that will automatically take attachments from a new line in smartsheet and be able to merge it into 1 pdf file with the print pdf of the smartsheet line. I have tried using power automate to computerize this process, but there is no option for me to grab attachments. I have…
-
Can I have a breakdown on how to use as timeline with PowerBi (Web Version) and Smartsheet reports?
Can I have a breakdown on how to use as timeline with PowerBi (Web Version) and Smartsheet reports? I am trying to create a timeline of projects from a report, but can not figure out how to integrate the two with the web version.
-
Unable to input external data to SmartSheet through API
Hi community members, I'm working on a project to fetch our students' quiz score data from Blackboard, an education platform, and send it to Smartsheet using the API. I've successfully retrieved the data from Blackboard and prepared it for transfer to Smartsheet, ensuring the data is correct and the column IDs match those…
-
How to select multiple options in dropdown by c# Smartsheet (NuGet 2.126.0 version)
Multiselect dropdown has values - One, Two, Three, Four and we need to select these options by sending values in c# I am using below method to add values cellsToAdd[cellCount] = new Cell.AddCellBuilder(columns[cellCount], true).SetValue(new List<string> { "One", "Two" }).SetStrict(true).Build(); It throws error of unable…
-
Continuous sheet updates?
Hello, I am trying to see if it is possible to duplicate a row in a sheet given certain criteria. I am trying to update status on certain tasks for people month to month. I have a checkbox saying completed as well as the dates. What I want is for the rows to duplicate when the checkbox is not checked(so not completed) and…
-
Emailing Smartsheet to Create a Ticket
Hello, We're looking for a solution similar to an existing JIRA solution and we know smartsheet can do all but one thing - do you know if we can email smartsheet to create a ticket? similar to how a user can email a request to Jira and the email request kicks-off the ticket. Thank you, Kate
-
Deleting Columns using API and python
I have a column that is identical on hundreds of sheets. I am attempting to delete the column using python and the API. I am currently just trying to delete it from one sheet using a script as a proof of concept for all of the sheets that have it. The column in question is a date column with a column formula. My…
-
Can't see check boxes or symbols. PLEASE HELP!!
Hello, I hope someone out there can help. For some reason today I can't see the checkboxes on my sheet or the symbols when editing the column type. I can't see the symbols on the sheet or in the dialog box that pops up when trying to change the symbol type. I can see symbols in columns on an old sheet where the column was…