-
How to format "row" when inserting record into Smartsheet
Hi - i have a Power App where i am assembling data to insert new row in SmartSheet and continue to receive "unable to parse insert row request payload". I have formatted the row via "Compose" action a few different ways to no avail. Here is latest attempt - note that I am replacing the variables('... using dynamic content…
-
API PUT and Body help for Cell link from a cell in sheet "a" to sheet "b"
I am having trouble linking a cell from sheet a to b. I am new to using API and possibly just getting the call wrong? or the body. Any help would be appreciated. PUT: https://api.smartsheet.com/2.0/sheets/4098048888098692/rows/1370574824361860/cells/259016080 Body: { "cells": [ { "linkinFromCell": {…
-
Why were all SDK GitHub repos archived?
I see that all of the Smartsheet SDK GitHub repos (https://github.com/smartsheet-platform) were archived earlier this year. In GitHub, archiving a repo makes it read-only and indicates that it's no longer being actively maintained. Can you please shed some light on why these repos were archived? Are they being replaced…
-
API Access Tokens for non-licensed Users
I've seen varying information about who can generate an API Token. For example, I am a "free" unlicensed user who has access to a licensed user's sheets. That licensed user is part of the Enterprise plan. I am setup as a "Viewer". When I try to generate a token, I get a message saying I need to Upgrade my plan. Can anyone…
-
Smartsheet app authorization
Greetings, Looking for a little guidance. I would like to develop an app that sends data to a sheet through HTTP. I have used the Python SDK with a raw token in the past but now I need a more secure solution and figured creating a 3rd part app is the way to go. I am having trouble with the workflow. Whilst following the…
-
How to programmatically erase a date column cell, with project settings and dependencies enabled?
Hi everyone! Need your help! I'm currently facing a challenge while attempting to programmatically erase a date column cell, with project settings and dependencies enabled. I am able to change the date, but not able to erase the existing date. I can successfully delete the column value manually, but I'm not able to achieve…
-
Drop Downs - Can a Response Trigger the Cell to Change Color?
Hello, Is there a functionality whereby a cell changes color when someone chooses a drop-down choice? For example, my drop-down choices are: Paid Overdue Sent Is there a way to trigger the cell to change to Green if 'Paid' is chosen, Red if 'overdue' is chosen, and Blue if 'Sent' is chosen? I know there are rules I can…
-
How could we know who add/create new column?
hello all, My smart sheet just showed 3 new columns, I checked with my teammates and none of them add those columns so is there any record we can track for add/create column? In addition, new columns content is quite similar with one of the column, not 100% match , but partial of it, column name is more or less the same as…
-
How to get access token in Smartsheet
I have a my service account with email id , using that I have to get access token from Smartsheet to do more calls Is there any API for that ?
-
Determine all of the workflows a user is assigned to/included in
Prior to deactivating a Smartsheet user, is there a way to see what workflows they were assigned to across all Smartsheet items? Oftentimes, the employee replacing that user will need to replace them in the workflows. Is there an easy way to do this? Even just knowing what workflows someone is involved in would be VERY…