-
How do I get the Metadata from the Smartsheet?
Hello All, I am able to get the Row and Column from the smartsheet JSON response but in it there are no metadata. I used things like: params = {'include': 'objectValue,objectProperties,format,formula,columnType,options'} and passed it with the request. But I still do not get any metadata. Specifically, I am trying to get…
-
How to process pages in Bridge
Hello friends - how do you "loop" your workflows to process multiple pages of data in Bridge? For example, if I GET a Sheet, 500 rows at a time, and have 5 pages to process, how do I get page 2 when I'm done processing page 1? I tried using Alt-click to loop back to the top of the workflow but that doesn't work. Once…
-
Smartsheet Bridge/Add comment to Row
Hello, I am using bridge-add comment to row in Smartsheet Module. For the comment, the user is always me. However, I would like the user who trigger the workflow create the comment. Is that configurable? THank you!
-
Mapping checkboxes
Hi! I am currently mapping a fillable PDF for document generation. When I map the checkbox field the checkbox is huge and not within the box. See pic below for example. How can I make this smaller and fit. Check should be next to Add MRM Thank you!
-
How can I connect project names to a project #?
I am looking for a better way besides individually making automations. That allows me to connect multiple project names using a drop-down list to a specific project number.
-
Error 5262: "Unable to create the requested cell link(s). The source data is no longer accessible."
Hi, I'm getting this error message when attempting to create a link from a cell in another sheet (through creating a cell, a row, and then update_rows method). Has anyone seen this error? I'm reading a discussion on another thread that this error is related to some issue with profile data (?), but I can create this link…
-
Python API Copy Sheet - Data not copying to new sheet
I am copying a sheet (source) to a new sheet (destination) using Smartsheet's SDK API. The copy of an empty sheet is the result. I tried the include parameter but it makes no difference. Does anyone know the correct syntax to use so when I copy a sheet the data within is copied to the destination sheet as well? Here's…
-
Inbound Links
Hi, I have a sheet with a million instances of "Used in Formula on <unknown sheet>". Is it possible to delete the "unknown sheet" references using the API and Python code?
-
What is the maximum limit of batch size to insert, update, or delete the rows?
Hi, For https://smartsheet.redoc.ly/tag/rows API for "Add Rows", "Update Rows" and "Delete Rows", how many records can we insert, update and delete per call request? Is there any limitation in the number of rows or batch size? If so, what's the limit and what kind of error would we receive beyond the limit? I did not…
-
Smartsheets and Acumatica
Acumatica shows a list of templates that can be used with the product. We have created several and have issues finding out new templates after publishing them. I wonder if anyone has found a way to find missing templates.
