-
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.
-
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…
-
Locking of Columns by Groups
Please add the capability to lock/unlock fields/columns for editing by Group Assignment. While Groups can be assigned with or without editing permissions to a sheet, Columns can only be locked for editing so that only administrators can edit locked columns. Being able to assign permissions that would only allow users in…
-
Request to Remove Additional Users from Account
Hello, I am facing an issue with my monthly billing over the past two months. I noticed that my bill increased to $120 instead of the usual $72. It seems that additional users were added to my account, even though I did not request this. I have a plan for 3 users only, and I would like to ensure that my subscription is…