-
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…
-
define user
Hello, I have a specific cell. When a value is entered into this cell, the person who entered the value should fill out a form from another sheet. I've tried to implement this through a workflow, however, in my sheet are many editor columns as there are different roles in a row, so it's not possible to define who should…
-
Form has a contact list field, for the contacts are not pulling into the form
Hi, We created a form to take in change request. The sheet has a column 'Interested Party" and this is a contact list. When i am in the sheet, i can start typing a name and the contact list based onthe spell comes up. This does not work the same in the form. Is there a setting that I am missing?
-
Bulk Upload Contact Profile Data
As admins, we are unable to bulk upload profile date such as title, location, company, phone #, etc. Today I learned it is not available through the Bridge API. This means we are reliant on individual users to update their own profiles. This also means we cannot lock profiles down to legal names; users can change their…
-
Need a report of the Jira connector users usage
Hi Team, I was asked about the amount of users that are using the Jira connector to Smartsheet. I know that in the user management report there is one role called Jira Admin but we need the users that are collaborating with the Jira connector. This is important information to understand how much important is the JIRA…
-
Contact list of users
Hi, We are currently creating a sheet/form for staff to submit a trip plan. This requires noting each staff member travelling in the vehicle so a new column for each staff, which then pulls through their emergency contact information. At the moment, for each column, I am having to add the staff names to the contact list so…
-
Contact list of users
Hi, We are currently creating a sheet/form for staff to submit a trip plan. This requires noting each staff member travelling in the vehicle so a new column for each staff, which then pulls through their emergency contact information. At the moment, for each column, I am having to add the staff names to the contact list so…
