-
Can Smartsheet auto populate data from a pdf to one of the sheets?
I am working with a client and I actually build workflows in Smartsheet for different clients based on their requirement. This particular client has an editable pdf which they send out and get it filled. Now that they decided to use Smartsheet, I want to see if I can link this editable pdf to the sheet in Smartsheet and…
-
How to retrieve the only past 5 days created row using Smartsheet API
Hi All, I'm exploring the Smartsheet API. My use case to extract past 5days newly created records from my "ABC1231231" Sheet using Smartsheet API call. Kindly advise me which API method i need to use and how to use the Date query filter?
-
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…
