-
API issue to add columns to a sheet
This discussion was created from comments split from: Add_Row Data Format.
-
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…
-
Shared mailbox does not receive notifications from requests submitted via smartsheet request form
Hi Team, Hope you are doing good. We have built a request form in smartsheet for stakeholders to submit requests to us. When testing, we noticed that when the request is submitted from a shared mailbox (within the company), the mailbox does not receive notifications about request changes/comments added to the request. Many…
-
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
