-
Printing schedule in Resource Manager
Our scheduler would like the ability to print a report showing all scheduled resources for the following day. This would allow him to take this document home and handle re-routing resources when people call in sick without having to log in each time to RM.
-
Create a Drop-Down List from Another Smartsheet
Greetings! Does Smartsheet include a feature that allows for the creation of a drop-down in which the selection choices are pulled from a column in another Smartsheet? Thank you, John
-
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…
-
Column wise restriction needed in smartsheet for different users
I need help enabling column-wise restrictions in some of my sheets. (Suppose I have a sheet with columns 1 to 10, also I have 5 users with Editor-Can share access. Assume User1 needs to access only columns-1 to 4, User2 needs to access and edit only columns 5-6, User 3 needs to access and edit only column 7, User 4 needs…
-
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…