-
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…
-
Freeze Column issue
Good afternoon, We have a Freeze set to maintain the view of a certain columns that are referred to throughout the day. However, the freeze doesn't actually work as expected, as almost every time I go into our sheet the pane has been moved either direction which defeats the purpose of keeping certain columns visible at all…
-
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…
-
I have a "Current Project Log" with 2024 accounts. How do I move to "2024 Log" & keep dashboards?
Hello, Due to the size of our log I can only keep 1 year's worth of data in a sheet. I have monthly and YTD metrics/dashboards that pull from the current sheet. I need to move 2024 into a new sheet to make room for 2025 projects, but I know doing this will cause issues with the dashboards. Is there a way I can do this…
-
New Column Type: Time
In Sept 2023(ish), Smartsheet introduced a TIME function. To further utilize this function, a new column type should be added, called "Time." This column type will function similarly to the "Date" column type in that it will only accept values formatted in a specific way and, most importantly, can be used to trigger…
-
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…
-
Find and Replace Function in Formulas
Having the ability to find and replace items in formulas would be incredibly helpful and save time as we update certain sheets each year.
-
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
