-
Sheet Access Report
Hello Smartsheet Gurus, I just pulled my Sheet Access Report and it's missing the Unique Key data point. Is anyone else seeing this when pulling the Sheet Access Report from the Admin Center?
-
Report filters are locked and I'm unable to edit them
When building this report an incorrect filter was added to the report (see picture). After it was added, we were unable to delete the filter, edit anything within the report, or edit columns in the sheets tagged to the report. Does anyone have a solution to this?
-
Timeline View - Printing
Can Smartsheet confirm how a timeline view can be printed? The ability to be able to print a timeline would be super helpful and a basic requirement If this is not currently available can Smartsheet confirm if its on their development roadmap and when its likely to be released?
-
Check a box if date is in the past or in the 60 days
Hello! I have this formula that will check the box if the date in a second column is in the past. Is there a way to include if the date is 60 days in the future? Check the box if the date in Column 2 is either (1) in the past or (2) 60 days in the future. IF([GWO - BST (2yr)]@row < TODAY(), 1, 0) Thank you in advance!
-
How to extract time from Date created auto column?
Hi all, I want to extract only time from Date created auto column (in format HH:mm:ss) I've tried VALUE(RIGHT(Created@row, 8)), but it seems i can only take two first numbers and ":" is blocking the formula, and i get unparsable if i go any higher than VALUE(RIGHT(Created@row, 2)). What would be the correct approach to…
-
Workspace Ownership Transfer - Owner Not Visible in User List
We have a workspace owned by a person who left the company. The wrinkle is that the user does not appear in the user list (was apparently previously removed). As a result, the 'normal' transfer process isn't available. Is there a workaround for an admin to be able to do this under these circumstances?
-
Keeping attachments with Index row value
I have a sheet where I query 14 other sheets to collect all sorts of data (unique values from sheet into a column) and in another column I use an Index distinct collect to get all the unique value from those 14 columns, this is the 'Index' column. At some point a user will want to generate a certificate associted with the…
-
Using Smartsheet for SOP / policy acknowledgements?
I’m exploring using Smartsheet as a central place to manage SOPs and internal documents and was curious if anyone is actively using it this way. Specifically, I’m interested in how people are handling things like: Notifying staff when a new SOP or document is posted or updated Requiring staff to acknowledge they’ve read it…
-
How to do cell linking in new Smartsheet lauout
Trying to link cell from other sheet and I'm not finding the symbol for it in the toolbar. I have the new layout. Anyone know have to do that?
-
App never loads
everytime I try to open the app on my phone it just says loading and spins and spins and then a message pops up that says “this is taking longer than expected.” I have only been able to successfully open the app once in the last 3 months and that was the first time I used it. Anyone else struggling with this or have…