-
Checklist population with info from another sheet
Hi team! I'm hoping one of you wise Smartsheets gurus have some guidance. I am trying to build out a "checklist" that will populate with data from another form and for the life of me I cannot figure it out! For a little more context, I work in the Mortgage industry. The documentation needed for each loan can vary,…
-
Updating Column In Smartsheets Through Python API
Hello! I am trying to update a column in a specific smartsheet using the update_column method from the Python SDK. I keep getting the error: {"response": {"statusCode": 400, "reason": "Bad Request", "content": {"errorCode": 1032, "message": "The attribute(s) column.id are not allowed for this operation."} But, if I set the…
-
Does anyone have experience with Celigo to Smartsheet API Syntax?
I am using Celigo but have been stumped on proper syntax to update a row in Smartsheet from NetSuite. I am able to identify the Sheet ID, Row ID, Cell ID but have not been able to successfully update a row. Have tried to use different variations of: rows.id[2691881577385860].cells[17].value with no luck. Thanks in advance…
-
negative numbers formatted as text
I am using the JSON string below to add rows to a sheet via the API However if the value is negative, as in this case, the value is entered as a string rather than a number so -9987.5 becomes '9987.5 Positive values work just fine I believe something has changed recently as this didn't happen before. How can I specify that…
-
Merge all attachments of a sheet into one PDF?
Is there any way to automate merging all of the attachments of a sheet into one PDF? I was thinking of using zapier or Microsoft Flow but I haven't been able to figure out a good and simple way to. Ultimately I want the end users to be able to do so with only one trigger (after the sheet has all of the attachments.) Thanks…
-
Attach an existing Dynamic View to a sheet programmatically
I know there is no API for Dynamic Views yet, but I'm looking into building some automation for a client and wonder if there is a way to programmatically assign an existing Dynamic View to a new sheet. It doesn't look like when you copy a sheet and create a new one via API, the Dynamic View associated with that original…
-
I Cant seem to get my gif work on a smartsheet dashboard
I like the design of the smart sheet PMO dashboard setup(link below) and attempted to design a replica for my solution but have not been able to figure out the gif part. After converting my video to a GIF and ensuring that the size is below 30 MB I attach it to the dashboard but it doesn't animate. how can I go about this…
-
Report fetched through API is restricted to 450 rows only
Hello, Please note that I am using Smartsheet api to fetch a report that has around 500+ rows. Syntax - https://api.smartsheet.com/2.0/reports/<report id> This is only fetching 450 rows and I have no idea where the remaining rows went. Based on few posts through Google search, I tried pagination ways like - #1…
-
Sending form attachments to their own smartsheet or google drive folder
Hi everyone, We're currently trying to create a system that accepts form entries with attachments and stores those attachments in their own folder as soon as they are submitted. Preferrably, we would like this folder to update in real time and remove any attachments that are replaced when the same user uploads a different…
-
Experience with DDUpdate?
I have been playing around with DDUpdate over the past few weeks. It has been working well until today, where all my mappings are now inactive. Fortunately, none of the mappings are in production sheets. For all you DDUpdate subscribers out there, how has your experience been? How is the support? Reliability? I logged a…
