-
Resource Management - Save Report options
In Resource Management / Analytics. When saving a report, it would be helpful to have the option to Save the Report to both the personal page and analytics page.
-
Column management
It would be great to have a place to see / edit column titles and attributes. Maybe this already exists, or the idea has already been posted, but I couldn't find it. I'm also sure I'm going about it the wrong way, but what made me think of this is: this morning I was working my way across a sheet changing the name of about…
-
How do you implement Deadlines?
This is sort of a feature request, but I'm posting here to see what other people do in Smartsheet or maybe even other planning software to show a deadline. It's a funny thing, as I've seen this better implemented in hodge-podge put together spreadsheets than I've seen it in actual planning software. In such spreadsheets,…
-
Flagging a Date and Time Overlap Across Multiple Days
Hi all, I need some help with a formula which I believe I almost crack but I don't know what I'm still missing here, I want to flag overlapping tasks across multiple days and times, as you can see below, I have different columns: Start date, end date, start time, end time. Start and finish are just switching the time…
-
How can I use one sheet to build onto another and still be able to manipulate the data?
I am pretty new to Smartsheet, and my office would like to account for requests using Smartsheet. There are two types of requests: Original and Supplemental. Supplemental requests build onto original requests. Therefore, if someone wants to request the same individual, they will submit a supplemental request because an…
-
Sort Order of Columns with Dropdown List -- Feature Request
Please consider offering more flexibility in the Sort functionality for columns with dropdown lists. I appreciate the column sort order following the dropdown list's order. But, it is missing a couple things. Allow the user to optionally select this behavior vs. sort on the actual alpha-numeric value in the column…
-
Help with COUNTIFS and CHILDREN Function
Hello! I am trying to get a formula to, automatically update status colors for the child and parent. The Parent is distinguished by "Main Project" in the "Project or Task" Column. I would like the Parent Row to update to show the worst status that aligns to the children status (i.e. if all children are green, parent is…
-
How to look across columns with checkbox data type to make them mutually exclusive?
I have 3 columns in my Project Plan that I am using to have team members fill in to indicate if their task is off track, on track, or complete. I only want them to be able to check one of the boxes. Is there a way to look across these 3 columns in a row to meet the following conditions: If Off track is checked, clear…
-
Finish Date Static vs Duration Static
Can the Finish date be static and have the start date and duration dynamic? Example: I have Task 1 and Task 2. Task 1 has a duration of 5 days and Task 2 has a duration of 10 days. Task 2 has a dependency on Task 1. But Task 2 has a due date that cannot change. If Task 1 goes over the 5 days by one day, I update the…
-
Formula/Function to pull new rows/updated rows to another sheet
Hi Everyone, We have a critical issues list that is maintained by another group, and I've created an end-to-end schedule that will determine whether or not we will have the issues "validated" by our Week 0 deadline. Since the source sheet is constantly being updated and new issues are added weekly, I want my sheet to be…
