-
Expand All/Collapse All Default View Setting
Would like to have the option to set the default view for a sheet with many parent/children rows, so that each time the sheet opened that default view would be shown. In other words, I'd love to have the default view at each opening of the sheet to show only the parent rows without having to choose collapse each time.
-
How can I use index match + either another index match or an IF statement to pull Data from multiple
How can I use index match + either another index match or an IF statement to pull Data from multiple sheets? In my case I have 3 sheets: Sheet 1 - Current Project List - consists information that track active projects. (each Project has a unique project code) Sheet 2- Closed Project List - consists of previous years…
-
Target Date/Delta info vs Baseline in PMO plan template
Hello! I've read through several past posts related to this but couldn't quite find my answer. We are using the PMO plan template and have activated the baseline feature. My manager has asked if there is a reason to keep the Target Start/End date columns as well as the related Delta columns since they're basically the same…
-
System generated Created (Date) column keeps changing itself to regular Date column.
I have a column that I'm setting to the type of Auto-Number/System that I'm setting to Created (Date). Some time later, it changes itself back to a regular Date column. I've re-set it numerous times and it keeps happening. Each time, I save and re-fresh and it stays for awhile. I've moved around and added and deleted…
-
Merged: New Column Type: Time
This discussion has been merged.
-
Right Click new Tab or window
Enable Standard Browser shortcuts - Smartsheet has disabled some standard browser functions. This is one of the top 10 complaints I get from users. you can not right-click and open anything in a new tab or window. You can not hit Ctrl+Click to open in a new Tab. Mainly the left toolbar. I would like to see all standard…
-
Automatic Phase from WorkBreakdown
Hello all! I'm modifying the Simple Portfolio Work Breakdown Schedule and having a little trouble. I like the way the Work Breakdown structure works but I'd really like an automatic way to track which Phase something is in. I know I could just add a column and manually select which Phase tasks and sub tasks are in, but I'm…
-
Edit in Proofing
What would you suggest to a customer who is looking to use the proofing tool to collect comments and request approval but would also want to be able to make changes to the word document without having to leave Smartsheet? At the moment they have to go out of Smartsheet, find the document in Sharepoint and edit the…
-
Sort column containing dates in chronological order
· Problem: It is not possible to sort a column containing dates by chronological order · Use Case: list of annual leave for employees working on a project · Ideal Solution: Enable sort by: chronological order for a column containing dates
-
Permit formulas in columns with the "Restrict" value toggle enabled
I have columns that are set to take certain types of data, and they contain formulas that fill the cells with values permissible within that data type. For instance, there's a field where a formula fills in one of several options based on a cell reference, or the user can manually select one of the options from a dropdown…