-
Access
Im having issues with access. I'm sharing sheets with internal employees and for some, the access is working being able to edit sheets and for others it is not. Can you help me troubleshoot this problem please? Note: the employees listed on the account as contributors are having access even though im sharing the sheet with…
-
Abnormal Display of Hyperlink Content in Notification Emails
Hello, Team Our team has encountered an issue while using Smartsheet. We have applied the Hyperlink function in a data management sheet to link the Quote ID to the corresponding sheet. This hyperlink is integrated into the automation workflow of Approval Requests. When a requester initiates the approval flow, the hyperlink…
-
How to preview Microsoft Excel documents attached to a Row in Smartsheet?
I frequently receive Microsoft Excel files which are then uploaded to a row in Smartsheet along with other files. I can view Word docs and PDF's simply by clicking the file in the Attachment window. If I click an Excel file (for which I see an Excel Icon) I get an error screen saying "can't open plugin" How can I fix this…
-
Identify who added a particular user to a particular group
We would like to get some info regarding audit visibility for group management in Smartsheet. We are currently unable to determine who added a user to the group. We check the Admin Center, but could not find any information. Could you please let us know if there is a way to: Identify who added a user to a particular group,…
-
Modified SUCCESSORS() function to report more than just direct successors
WHY IS THIS USEFUL? This updated function would allow us to filter the spreadsheet for only the driving path to a particular row#. This would be similar to a filter for critical path, but enable much more flexibility. Current status: I've successfully generated a "Successors" column, listing direct successors of each row,…
-
'Helper' Column Management via New Column Type (or Side Panel?)
Many of us, if not most, use one or more helper columns to achieve the Sheet functions that we need. Good practice is to hide the helper columns (when possible) so that the sheet user isn't bombarded with noise. Unfortunately, hidden columns still appear while in Card View. My solution for this is to move all of the helper…
-
Welcome to the Government Community!
Hello! This is a space for Smartsheet and Smartsheet Gov users that work in all levels of government to connect, share ideas, challenges, best practices and how you are using Smartsheet and Smartsheet Gov to create impact. My name is Chris, I lead marketing for the Smartsheet Gov platform and am excited to get to know you…
-
Automation issue
I have one sheet that rolls up into another sheet. I notice that when it copies, if I add multiple rows at once and then press save, it skips a row. AI is telling me that the copy row automation does not reliably process multiple rows added in the same save action. Rows added simultaneously may result in only one being…
-
Blocking users from moving rows while being able to edit...
Hi all! I use our smartsheet for a roll call log. I have employees moving rows and it's really screwing things up. I need them to be able to edit a column with toggles that say "here", "sick", "vacation" but not be able to move the rows. Is this possible at all? I cannot seem to find a workaround. Either the entire row is…
-
Is the a formulas that counts cells? Sheet limit question
Hi, I was wondering if there a formula that can count the number of cells in a sheet? I'm trying to make sure we don't go over Smartsheet limits. Also do the sheet limits count all cells in a row or only those cell with information in them? Thank you Kim