-
Absolute Sheet References for use in formulas across multiple sheets
We use our own variation of the Project Management Template Set, and our PMs copy the folder when they are initiating a new project. We would like to include a formula in the project plan template for which the reference to another sheet will persist and work in the copy. This will help so that the PM doesn't have to…
-
Can you do a portfolio report on manually created project sheets?
I have a portfolio with 1 project template. I created 2 projects from the project template. I realized I need a Project Metadata sheet to facilitate the portfolio reporting I need. So I added a Project Metadata sheet to the project template and manually to the 2 projects previous created from the template. I've confirmed…
-
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…
-
Expand Font Options in Smartsheet to Support Modern Branding, Accessibility & Readability
I use Smartsheet daily for project tracking, documentation, and cross-functional communication. One of the biggest limitations I run into is the very small set of available fonts within grid sheets. Across organizations around the world, teams have moved away from legacy fonts like Arial and Times in favor of modern,…
-
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…
-
Sheet automation notification email tracking using a PowerAutomate Flow and Outlook
This post details how to track all sheet automation notifications emails. This solution is medium complexity and will likely require you to use an AI for some simple coding. Smartsheet allows users to automatically send email notifications from sheets. There are a few significant problems with these automated emails.…
-
Editing Dashboard and Worksheet
I created a dashboard and worksheet in our team's workspace a few weeks ago. Now, today I cannot edit either of them. There is no "edit dashboard" icon. What would cause this? How can I get back in to edit them?
-
Smartsheet Save-Merge Errors
We have a high-traffic sheet that frequently has rows deleted, and when we ask the user about it, they have no idea they even deleted the row. I have reached out to smartsheet about this several times, and they said they can happen due to a "save-merge error", and to have users save and refresh the sheet often. Instead of…
-
Some text are in Cyrillic in Functions list.
Chatbot is not helpful, cant contact support directly. Some text (header) are in Cyrillic. @Diegob @Daniel Medved @Genevieve P.