-
The new seat type report is available for System Admins!
August, 25, 2025 To eliminate customer confusion between the separate User List and Seat Type reports, we have launched a new, consolidated report to serve as a single source of truth for seat management. This unified view combines all important permission and usage information, adding key billing dates to make it easier…
-
User Identification to Site
Provide method within Admin to identify a User to a particular site. This is helpful when administering multi site users. I would like the User.csv output to contain the site that the user is assigned to. It would also be helpful to sort users by site in Smartsheet.
-
Users Removed from a Smartsheet Account but in a Company Created Distribution Lists Shared to Assets
I know Distribution Lists (DL) are discouraged and we continue to try to prevent users from using them, but there is no way to best manage this. We are currently on the legacy subscription plan but preparing to convert to USM so cleaning up our user lists REMOVING inactive and termed employees through the Admin Center:…
-
Trying to update a user's email address.
User email changed but when I try to remove and readd with correct address it adds the old one again. I've removed her several times and Smartsheet seems to remember the old email and won't allow me to add the new one.
-
CountIFS contact is in a contact list
=COUNTIFS({TEST Range 1}, ="*Name*", {TEST Range 6}, ="DO") Hi all, this is a helper sheet used to get the counts of different conditions. Test Range 1 is a contact list that can contain multiple contacts, how can i make it so that i can check if "Name" is in the list. It is currently returning 0 when it should be finding…
-
User List not matching from API and User type report
We wanted to report a discrepancy we had observed in the list of users we are obtaining from the Smartsheet List users API and the User type report generated in Smartsheet. We observed that a lot of users that were being coming in the API response were not in the User type report and also Vice Versa. We are using OAuth…
-
Bridge: How to automatically add users to "Licensed Users Group" or "Other Users Group"?
We're trying to maintain a "group" of users in our Smartsheet instance who are Licensed, so that we can use Smartsheet to share Licensed-user dashboards with them. And if they're not licensed, they would go into "Other Users Group" for a dashboard highlighting features available to free users. Currently, we intermittently…
-
Single User Report for managing licenses
I'd like a report the contains all the following information so I can manage enterprise licenses: Name Email Active/Deactivated Role License consumed? Last Login Date Group(s) We manage our license disbursement across the enterprise by using groups. But I can't pull a report showing group membership at this point.
-
Being Proactive with User Subscription Model User Management
I keep reading Smartsheet articles that refers to the User Type report to best manage our current users as we transition to the USM. The Sheet Access report helps identify who was shared to an asset, who owns the asset and when the asset was last modified. This allows me to put responsibility on the Asset Owners to audit…
-
No Activity Users on User Type Admin Center Report
In the User Type Report or any user report, users are part of your count which impacts your overall cost, for 365 days after their last interaction with an asset. When I run the User Type Reports, I have internal and external users with no "Last Activity" date and the # of assets viewed, commented, edit or created the last…
-
Sync User Management list with Smartsheet Contact Lists
It would be extremely helpful to have our users' first and last names and email addresses, as listed in the User Management List in the admin portal, synced with available contacts in the Contacts List to input as a contact in the Contact List column type. People are really confused as to why no names automatically show up…
-
Published Assets and Connect User Count - Shared Users
I had a few questions regarding the Connected User, what trigger a user to be counted as a Connected User and the effect of sharing published assets. Is one of the triggers to be included in the connected user count who is shared to an asset regardless if they don't have a Smartsheet login or whether they access or view an…
-
Do I need to update Contact List options when adding alternate email addresses?
Hi there — We acquired several companies a few years ago and kept the companies' email domains as part of our system. We've verified these domains on our Smartsheet account. However, we now want all the members on our account to use our main email domain. I updated the affected users, who confirmed their main email…
-
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…
-
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…