-
*NEW: Proofing using Reports
The new Proofing capability is something we would like to implement in our department, but we are having issues with accessing this in Reports. We see that Proofing can be done in the main smart sheet, but our Artists access new design requests via Reports so that they only see what tasks and designs are assigned to them.…
-
Search rows API after create rows API from Power Automate/Flow returns incorrect row object ID's
I'm attempting to have a flow in Microsoft Power Automate/Flow create rows in a Smartsheet sheet and update a field once an approval outcome is present. The first part works with no problem - rows are created with a value in one column to help identify (e.g., SR001) - but after they're created, querying the sheet for all…
-
Is there anyway to autonomously get a sheet's forms?
Hello, I've been working with the Smartsheet API to automate many different things but does anyone know if there is a way to autonomously get the forms that exist in a sheet? I need to dynamically grab the link to a specific form for many sheets in an ongoing project. Thanks!
-
Update linkInFromCell via API results in error 4000
Hi, i'm requesting the API via axios.js with PUT https://api.smartsheet.com/2.0/sheets/{sheetId}/rows to update two cells of one row with the following data body: { "id": 1234 "cells": [ { "columnId": 1234, "value": null, "linkInFromCell": { "sheetId": 1234, "columnId": 1234, "rowId": 1234 }, { "columnId": 1234, "value":…
-
Why do some reports/sheets return 1006 "Not Found" when trying to access?
I am making the simple "sheets/[sheet id]" and "reports/[report id]" calls and some of them return 1006 "not found". I have access to these sheets/reports from the Smartsheet UI, and obtain the ID through properties as before. There does not seem to be any pattern to the ones which return 1006. Even the ones I do manage to…
-
Error code 5570 when sending e-mail notification
I have a trial account with Smartsheet. I am using smartsheet API with curl to create/update few sheets. The requirement is to email these sheets at EOD to a couple of users. However, receiving error code 5570, 'you have exceeded maximum number of e-mails that your account can send'. The limitations document states that…
-
Getting 204 with Smartsheets put request on Postman but 400 in .NET Core Web API
I am testing the same data in postman verses a .NET Core Web API project, however, one returns fine when content is being updated and another (.NET Core) returns 400. Any ideas on why this may be? It's the same data structures, and even same data.
-
Do refresh token expire ?
In Smartsheet, the refresh token generated using the OAuth 2.0 flow , do they expire ? If yes, what's the expiry time ? (I'm asking for refresh token , not access token).
-
Is it possible to create a Smartsheet that spits out an image and data after receiving information?
Is it possible to create a Smartsheet that spits out an image and data after receiving information? I would like to create a Smartsheet that allows someone to enter in a product name and also a URL (two separate items). All entries for product name would be inputted into "column a" and all URL entries would be inputted…