-
Hyperlink Color on Dark Background
Hi, I'm new to SmartSheet so I may have missed something. When I add an hyperlink on a cell with dark background, is there a way to make the text white or any other color that would allow to read it? I thought the automatic mode would change the color, but it does not let me do so... any ideas? Do I have to stick with…
-
Make sheet data available to external 'viewers' but limited to only their data
Good morning Smartsheet community. I have been using Smartsheet in my job as the office manager for a small business. I'm self taught and have managed to get some workflow and automations working through trial and error. However, I am stumped on the next project that I'm trying to figure out how to best handle inside…
-
Creating data to populate a dashboard
Hi all, I want to display a count of a particular item from 1 column (dropdown with multiple options) but need it to also cross reference another column (dropdown with multiple options). So example is if first column (Site) is "Preston" and second column (Contact) is "Warehouse" then give me a count of this combination.…
-
SS giving message "Please log out and log back into the app before continuing" and not able to acces
All smartsheets from a workspace is giving the message "Please log out and log back into the app before continuing" when trying to access. Team logged out, cleared cache, used incognito browser and they are still getting this message. An entire team is impacted since yesterday. A case was opened on support however no one…
-
Sum(Children()) Formula Issue
My sum(children()) formula in the first row is resulting into zero. Idk why although I tried to double check that the numbers are formatted correctly. any assistance is appreciated.
-
Move the Deleted function to another section
Please move the Delete function away from the Edit function for a row in a worksheet. THIS CAUSES A LOT OF ISSUES JUST BY BEING NEAR EACH OTHER!!! Locking rows isn't an option, unless you can tell me if I can lock only certain columns.
-
When using the Workflow for deletions
When using the workflow "Alert someone when a row is deleted," it would be nice if we could have some of the information from that row in the message. For instance, I have an alert setup for deletions, however, it isn't able to capture the Request Title or ID number, because those fields are deleted when a row is deleted.…
-
Automating Email Alerts for Multi-Stage Document Review
Hi, I’m looking to set up email alerts for two stages of a document review. I’ve currently configured IF functions so that, once the ‘Document Received’ checkbox is selected, the status in the ‘Primary Review’ column automatically changes from ‘Not Started’ to ‘In Progress’. Stakeholders then tick off the relevant boxes in…
-
How to create Icons into a Dashboard
Wondering if anyone knows how to include a link on a Dashboard to other Smartsheet grids/ reports with icons (not just a list)- here's an example :
-
Add 'sort order' to Filter Views
I love the Filter Views feature in Smartsheet, but it would be really useful to include Sorting options in the Filter View dialog as well. Some of my filter views require sorting by different columns, and currently it's a bit annoying have to manual sort each time I change a view.