-
COUNT(DISTINCT(COLLECT to count unique values based on multiple criteria
Hi, I'm trying to count the dates we've worked on a job site, but we have multiple ones. Of course, at first, I'm trying to calculate just for one criterion. So far, I've tried using the Sheet Summary: =COUNT(DISTINCT(COLLECT(Date:Date, [Site ID]:[Site ID], "CUPERTINO"))) As per my database, I have 80 entries for…
-
Detailed asset access report showing assets actually accessed / edited during a set timeframe
Would like to have a way to get a list of Smartsheet assets that each user has viewed and/or edited within the last 90 (or 'xx') days? The Sheet Access report only shows the assets that each user is shared to - but it does not show you which assets they have actually accessed and/or edited. I would think this information…
-
How do I manage Unlicensed Admins and Editors user accounts
I am an admin on our Smartsheet account. When I open the Admin Center page and view the total users in our system, I see nearly 250 users listed as Unlicensed Admins and Editors. When I export the user type report I see that many of these accounts are no longer valid. I would like to "clean up" these accounts, removing…
-
Does anyone have a support phone number for Smartsheet
I don't seem to be able to find one anywhere. I'm handling coordination for multiple teams on a project and I have multiple resources having trouble receiving the account creation e-mail confirmation.
-
Option to Toggle off Admins Receiving Access Request Notifications
With the new update rolled out last month, all sheet/workspace Admins now receive access request notifications instead of just the Owner. This is causing major headaches for the large corporation I work for. We have thousands of users and many do need Admin permissions to perform their tasks in workspaces. However, they do…
-
Give Administrators full vision and access to all sheets
I recently contacted support about this and was amazed to find that what I thought would be a simple function doesn't exist. We have had staff leave recently and not so recently and have had requests from senior management to look for data that they may have stored in sheets that they may of owned or shared or transferred…
-
Do you know why Smartsheet 'forgets' my existing subscription?
I subscribed and paid for a yearly Pro subscription this October. Everything worked as usual for 3 weeks, then Smartsheet seemed to forget my account and email address completely. When I tried to sign in after 2 weeks of not using it, it requested me to sign up for the trial again. Nothing else worked with the same email…
-
Public Holidays
Hi, When we update our public holidays, it doesn't seem to pull through on project plans that were created 2017. Can someone please advise how we can get smartsheets to automatically update projects plans that were created in 2017 with 2018 public holidays? Please note that I have updated smartsheets with the latest public…
-
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…
-
Unlicensed user name.
Hello Everyone, I have updated unlicensed user name who's part of our organization. I can see correct name in Admin / User Management however, in PMO tasks it' still showing old name and If I edit assignee I can only see old name, not the new name! I was hoping that as soon as I update name in Admin / User Management it…
