-
Smartsheet URL and Redirect URL for connection with Celonis
Hello together, i am trying to connect Smartsheet with Celonis. I already have a Client ID and Client Secret but everytime I try to connect both, Smartsheets shows an error saying Redirect URI ist missing or wrong. Does anyone know what to fill out in the Developer Settings of Smartsheets in the field APP URL & APP…
-
Solution for Table Join-Like Behavior
I'm looking for some ideas... Being that Smartsheet is a project management software, I imagine there is at least one person doing something like this! Some Background For apartment complex renovation projects, we have a list of tasks that are repeated across many apartment units. Inside of that task list, there are also…
-
smartsheet api: how to read a certain cells value from google apps script
Hi all, could someone please help me how to read a certain cells value from google apps script? I have token, sheet id, col id and row id, but do not know how to do the code. Thank you, Joachim
-
SDK - Start/End time of a working day per file settings
Hi, User is able to set length of working day per file. Smartsheet is somehow using this value to set some internal Start/End time of a working day. Would be useful to have this values provided through the API. Or at least share the formula to do the calculations. Thanks
-
How do I automate Smartsheet API "get_sheet" function to go through a list of sheets and save data?
Hi, I'm currently creating a catalogue of all sheets in a workspace using the "get_sheet" function. The data I'm collecting (crossSheetReferences, cellLinkIn, LinksOut) can only be found within the "get_sheet" function. I have a list of sheet ID's (sheet_list) that I use for collecting data. My code (python) looks like…
-
ODBC Connection with Visio
Hi All, I am attempting to automate the creation of my Agency's Organizational Charts via Visio and the smartsheet ODBC connector. We have our "reports to" information stored in smartsheets and have used the ODBC connector to create several reports and tableau dashboards. In Visio, you have the option to create an…
-
Push Row with Attachment
Hallo, I create integration from my form on the website to connect to Smartsheet using API. I want to push data with attachment in one time process, it's that possible? Thanks,
-
Add data to Smartsheet by connecting to any API
I built a Smartsheet App called API Retriever that allows you to connect to any API, pull your data, and import it into your sheets. Check it out at https://www.apiretriever.com I'm happy to assist if you need any help creating a request. Let me know if you have any feedback or need any assistance!
-
RAG indicator at parent level Vs Child
Hi All, I need help on a formula. In my current schedule the RAG is determined by % complete of task, desired% as on today and low tolerance. Here the parent level is indicating RED although child is in green and blue but no RED. Probably due the Desired % is more than the actual % but the actual % for child task is more…
-
Fillable PDF
Has anyone tried to use the submit button on a fillable PDF form to send data into smartsheet? Doens't seem to difficult but could use some guidance.
