-
When I Copy Workspace, Everything Copies Fine Except for CellLinking
Hi, Using the API documentation, I'm able to copy entire workspaces which has been great for scalability. I've been noticing that the only thing that doesn't work correctly out of all the sheets, reports, and sights, is the cellLinks in my sheet. In the instructions, you can tell it all the different things to pull in. I'm…
-
Get cell history of all the rows in a column
Hello, This is a very urgent requirement I received from my team. They want the history of all cells in a column. I've spent quite a few hours exploring Smartsheet forums. However, the only solution I found was by adding the ID of each row and column individually via API to get the cell history of that particular cell. I…
-
File attachment using Node SDK
Hello, I am trying to add a new row and then attach a file to it using the smartsheet Node.js SDK. The first part of this is no problem, I can add a row using the SDK without issue. The problem is with uploading files, the post request from the smartsheet client takes a while to resolve and eventually I get the following…
-
Using Zapier to update a Form Sheet
Hi! I would love some insight on if I can use Zapier integration to update a form sheet. I created a form for new job requisitions. I need to be able to receive updates from our legacy system as the status changes for each job req. Data Shuttle is not an option as the enterprise does not plan to support it. Could Zapier…
-
Delete/Remove/Clear Hyperlink using API
While there are a wealth of articles, discussions, and examples of adding and updating hyperlinks in cells using the Smartsheet API, I struggled to find any concrete guidance on how to remove a hyperlink or clear a cell that contains one via the API. I need the equivalent of going into the sheet, hitting "Delete" in the…
-
Getting this error while offloading data what is the issue anyone knows please help me
Offloading to google drive from smartsheet
-
AutoNumber systemColumnType via API
I am trying to add a AutoNumber column type to a sheet It seems to work just fine The issue I am having is the "autoNumberFormat" seems to be ignored. I can go into the smartsheet.com and manually edit the prefix, and suffix, and starting number in the sheet and it works fine… but the API isn't applying this on column…
-
"autoNumberFormat" seems to be ignored
I am trying to add an AutoNumber column type to a sheet It seems to work just fine The issue I am having is the "autoNumberFormat" seems to be ignored. I can go into the smartsheet.com and manually edit the prefix, and suffix, and starting number in the sheet and it works fine… but the API isn't applying this on column…
-
How to unselect an option under "What templates should this appear in?" in Control Center
Hi All, I'm hoping to unselect an option under the "What templates should this appear in?" in the Customize Portfolio Data section in the blueprint in Control Center. However, the checked options are greyed out and cannot be unselected. Does anyone know why this is and how I can unselect one of the options? Thanks!
-
How can I pull reports data from Resource Management connect to Power BI?
I'm not a developer and my knowledge of APIs are limited. I'm working on getting data from the resource management tool to power bi. I was able to pull all data, except for reports. I know I have to do a POST request, which I'm trying for the first time. I did run this query and I'm still getting errors. I'm getting this…
