-
Report on User Access when Users are not Registered in MY Smartsheet system
We have an application that has been built on Smartsheet. Several of our clients have the users of our system as Licensed (or unlicensed) Users in THEIR Smartsheet system. Because of this - we cannot add them in our Smartsheet system. We would like to get a report that shows the utilization of OUR system by THEIR users.…
-
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…
-
Barcode Scanner Options
Hi Hoping someone will be able to help. I’m looking into options for using the barcode scanner to help automate our production schedule. Currently we are using SmartSheets for all orders and manually ticking stages off (Printed, Staged, Built, QC, Shipped etc). I have added barcodes to orders so the team can scan them…
-
Can Smartsheet integration update the Harvest Forecast?
Good afternoon I'm hoping someone can assist me with some advice please? I have a client using Smartsheet for projects and Harvest for Time management. If we connect Smartsheet with Harvest, would the tasks created in a Smartsheet plan be able to update the Harvest Forecast? Looking for some advice from anyone with…
-
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…
-
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…
-
How to use access_token? (api.smartsheet.com/2.0/token)
Node.js How to use access_token? I'm making a request: axios.post('https://api.smartsheet.com/2.0/token')... response: { access_token: 'xxx', token_type: 'bearer', refresh_token: 'xxx', expires_in: 604799 } var smartsheet = client.createClient({ accessToken: 'xxx', logLevel: 'info', }); But the result is always the same:…