-
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…
-
Is it possible to recover the cell links?
Is there any way to recover the cell links that are lost when rows are moved and subsequently deleted in Smartsheet, leading to the loss of both data and the associated cell links?
-
Is it possible to retain outbound links when copying a sheet?
Is there any approach to retain outbound links when copying a sheet using the Smartsheet API and/or manually? Thank You!
-
API with Java SDK - Sheet Summary
I am trying to create a sheet summary field using the API in Java. I followed the example as they show on the API documents with java, but when I do the following: smartsheet.sheetResources().summaryResources().updateSheetSummaryFields(); it tells me that The method summaryResources() is undefined for the type…
-
Can we create new custom user roles in Smartsheet?
Does Smartsheet provide any facility to create custom roles and assign it to user using any REST API? Currently we are only able to assign Group Admin, System Admin or Resource viewer roles using /User endpoint. I also observe some roles such as owner, admin, editor, viewer or commenter. Does it also related to Smartsheet…