-
"Sheet Name" column for Sheet
I have a report that pulls data from multiple sheets. Sometimes I want to know what sheet the data came from. The Sheet Name column on the report provides the name of the sheet from which the data was drawn. However, due to the formatting of the Sheet Name column, it's not easy to spot when data comes from certain sheets…
-
Merged: Sharing through Control Center
This discussion has been merged.
-
Is anyone else struggling with duplicate assignments (i.e. Assigned To field)?
Hello! We recently moved a manual task assignment process to Smartsheet. The issue we're experiencing now is duplicate assignments. 10-12 team members are accessing the sheet at any given time. Changes are happening all the time. And while they are refreshing and saving consistently, team members are stepping on each…
-
Solution to analyze multiselect dropdown data and visualize in a reporting dashboard
Hello! I'm somewhat new to creating reporting dashboards in Smartsheet and I'm running into issues since one of the key metrics my sheet has is a multiselect dropdown. I'm aware that you cannot group by a column that has a multiselect dropdown, but what would be a workaround for that so I can visualize that data in a…
-
Clarification on Asset Access When Licensed User Is Downgraded to Viewer (USM Model)
Hi Community, Under the User Subscription Model (USM), I’d like to clarify what happens when a Licensed User who owns sheets or other assets is downgraded to a Viewer. From my understanding: The user will no longer be the owner of the sheet or asset. However, they will still retain access to the item, but only as a Viewer.…
-
IF((CONTAINS)) function
I'm trying to verify that the emails in a column have the correct spelling. I'm using an IF((CONTAINS)) function, but it's not working =IF(CONTAINS("@kintegra .org", EMAIL@row ), "", "Check eMail")
-
Health Ripple Effect Formula
On my project plans, I use a Red/Yellow/Green/Gray column called [Health], and I also use the stock [Predecessors] column. I'm trying to come up with a column formula so that if I change the [Health] value on a given row, it will update the [Health]@row value of every row downstream that directly or indirectly uses the…
-
Printing a Gantt Sheet
Hello I would like to suggest if there is a way to have the columns print the same in a gantt sheet as a grid. For example, when I change the sizes (smaller or larger) of some of the columns and then export the Gantt sheet to print- it changes the sizing for printing. I look forward to seeing this change. Thank you!
-
Show all files that are pulling information from a file
We want the ability to see (on any file type) what other files are pulling information from the current file we are on to understand the dependency between sheets/dashboards/reports/etc.
-
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…