-
Unable to Print
I had two nurses call and tell me they are no longer allowed to print their shift report from SmartSheet. Trying to print from the browser leads to a blank print preview page and the below message; there is no print option available on the SmartSheet toolbar.
-
Help with functions for attendance tracker
I'm attempting to create an attendance tracker that will add up the total points for a given representative based on the type of 'event' such as No Call No Show, Late Arrival etc. I have a sheet set up that automatically enters the number of points based on the event, calculates any adjusted points and shows points…
-
Formula not Calculating the Correct Number
Hello, I have a formula that counts notifications that are tracked on another smartsheet each month. The formula is: =COUNTIFS({Date of Notification}, >=[Start Date]@row , {Date of Notification}, <=[End Date]@row , {Impacted Department}, <>"XX") The results from this formula are no longer calculating correctly. For…
-
Contact Columns ≠ Consistent Data
The Core Issue with Contact Columns Smartsheet Contact columns are fundamentally not reliable because they don’t represent people consistently. The same person can appear as a name in one place and an email address in another, depending on user status, permissions, ownership, or whether the data is viewed in a sheet,…
-
External User Access
Hi! We are reviewing the the 'Seat Types & True Ups' menu in our Admin setting in Smartsheet. When filtering under the external users (not in our domain and people who never had licenses) there are numerous emails listed and we have zero idea what specific items they could have access to. We've run all the reports offered…
-
Mysterious Date Changes... Dependencies and edays?
Hello, I've had a few users reach out to me today about seeing changes to their project plans, but no one went in to change dates. The activity log was clear of anyone specifically doing anything to affect the start and end dates. The recent user, after investigating her plan, had a predecessor (our dependency column) that…
-
Add Column Description to Update Request
Include the column description when an update request goes out to provide some context to the column if it has a generic name.
-
Keep "Sheet Reference Manager" open after creating a new reference: create multiple references
I often setup all of the cross sheet references from the Sheet Reference Manager before addressing any formulas. Currently, the reference manager closes after adding a new reference. If I am adding several references, this means right clicking on the sheet and selecting the reference manager again before creating each…
-
Getting errors trying to transfer ownership of a sheet
We have MANY sheets to transfer. This is as a result of our company domain changed (hii-tsd.com to hii.com). So we transferred ownership to 3 people (myself included) on the Portal Team, who manage the Smartsheet files. I had a co-worker on the portal ACCEPT the email that was sent to the shared mailbox, and then the…
-
User Subscription Model: Non Admin access to Users Seat Type
Hello, I am a System Admin and want to provide assistance for Workspace Admins at my company with regards to User Seat Types. From this help article: https://help.smartsheet.com/articles/520104-share-sheets-reports it mentions this: "Ensure that collaborators you’re sharing your sheet or report with have the right account…