-
Wildcard selection of sheets for reports
Per FAQ I tried searching for this idea, but the search engine seemed to exclude some words from my search when listing the results. However, I would be surprised if no one has previously suggested this. What problem are you trying to solve? When creating reports for a Smartsheet instance with a large population of sheets…
-
Visual indication of child rows when mouse hovers over the +/- icon of a parent task
Use case in mind: Working within a complex project plan containing lots of hierarchy. (Possibly with outdated and messy content...not all of us PM's are perfect =/) Having to open and close parent tasks often as you build out or make large structural updates to a plan. Opening and closing a parent task can be a bit…
-
Extract Cell History For Formulas
Hello, Is there any way to extract the Cell history to calculate formulas. What I am trying to do is create metrics off the dates in the cell history. I.E. if a Dropdown list column starts on July 1 with Value 1 and changes to Value 2 on December 10th then Value 3 on December 21st. I want to measure and tract the time…
-
Merged: EU account backup
This discussion has been merged.
-
How to COLLECT() a different reference value for each value in a multi-select column and SUM() them?
I have a cost matrix similar to this staged one: The cost matrix is referenced in a second sheet of "buyer requests" to determine the cost of their request based on the Type, Size, and Vendor they chose: When only ONE Type of Material is requested, the following formula works: =INDEX(COLLECT({Cost}, {Vendor}, [Preferred…
-
Sharing folders
Since Workspaces is not conducive to individual permissions, we are trying to use the standard folders under "Sheets". One department has close to 100 files in Smartsheet. We want to use Smartsheet in other departments as well, but would like to organize the departments by folders. With each Sheet, Report, and Dashboard…
-
Allow multiple contacts in Dynamic View "Restrict view by current user"
Summary: Allow the admin to select multiple contact lists in Dynamic View when restricting what the current user can see. I currently have a portal for our various locations to report temporary issues. A good example of this are the recent hurricanes in Florida. Currently, the Dynamic View only allows the submitting…
-
Merged: Strikethrough, for selective text
This discussion has been merged.
-
Column Filtering for Sheets
Enhancement Request: Filters on sheets are a wonderful addition to Smartsheet. Since they were introduced, we have learned to rely on them more and more. One enhancement we would like to see is the ability to filter columns in addition to rows. Please add my vote for this feature. Thanks!
-
Merged: Make the name in Latest Comment row optional
This discussion has been merged.