-
Bulk Copy of Access/Permissions
Any time I need to create a new sheet, I find myself entering the shared recipients line by line while referencing another sheet with similar permissions. It would be nice to just have a "copy all permission to another sheet" where we can do a bulk upload of all shared access and validate the list before sharing the new…
-
Merged: Bulk delete user
This discussion has been merged.
-
Populate a contacts drop down list when adding a new user to a group.
We have a sheet with a contact list drop down. What we would like to do is have the user's first and last name with their email address added to this drop down list when the account is created and added to the Everyone group. Has anyone else looked at this option?
-
I have a blank sheet that i want to populate with only the column values from another that contain X
Hello I have a fresh blank sheet, and another data sheet that for example contains the Columns: Fruits, Fruit price/kg, Inventory, etc I want to in my new blank sheet have a Fruit column that only includes the ones with string "apple" so data sheet may contain: Pineapple, green apple, red apple, AND, Orange, Banana,…
-
ServiceNow SaaS licensing integration with Smartsheet
Hello Community, We have successfully established the connection with ServiceNow. However, when attempting to pull user subscriptions from Smartsheet, we encountered an issue where only some users' subscriptions were retrieved, not all. Subsequently, an error occurred indicating:{"errorCode":1013,"message":"The operation…
-
Build report off activity log data from a Sheet
I know that I can download an activity log from a Sheet, but is there an easy way to build a report off the activity log data? I want to track metrics like # of sheet views, unique users using the sheet, usernames in the sheet, etc
-
Collaborator Count
In March '24 we switched from Chrome to EDGE. Before I was able to see the # of collaborators in any Sheet, but now in EDGE the count is missing… I learned that this function no longer works in either browser, but hovering over Share reveals the count. Now recently, I discovered hovering over the Share button no longer…
-
User data reports
We've been trying to build some insighful anaylicts for our leaders and I would like to show consumption (views) of dashboards and sheets, but I want to be able to separate internal users from externals. This analytic is a bit manual since when downloading the Activity Log, I'm not able to separate all the internals from…
-
Is there a way to populate a Report based on Project or owner?
I'm trying to create a report based on projects and owners. For example, I might have ten projects and multiple owners of each project. I can populate the project list but cannot find a way to include Owner My steps so far: Create Report Sheet Summary report Select projects I'd like to include, this could be single or…
-
/users API throwing User not found.
Fetching all users using below API fetches all the users with status, ACTIVE, DECLINED, DEACTIVATED. https://api.smartsheet.com/2.0/users But when we try to fetch the single user using https://api.smartsheet.com/2.0/users/abc If the user abc has status as DECLINED. It fails with error { "errorCode": 1020, "message": "User…
