-
How to trigger dropdown to populate projected completed date based on specific complexity?
I want to trigger these drop downs in the "Complexity" column to populate a date in the "Projected Complexity Completion" once a dropdown value is selected and once status changes to "active". Low Complexity = 2 days Medium Complexity = 5 days Most Complex = 10 days
-
LOG Function
Is it possible to calculate (or even approximate) a LOG function in Smartsheet? We regularly use the below formula to calculate A/E fees: (35/LOG(Construction Cost))-1.15)*(Complexity Factor) = A/E fee % I have a sheet setup where someone can enter a construction cost, and a lookup table for the complexity factors based on…
-
Integrate Smartsheet Baseline with Resource Management Time Budget
We are utilizing Smartsheet for Project Management. We use a Project Plan sheet to set the schedule (start and end dates) and then set the baseline for the project. We're utilizing control center to create each of our projects in Resource Management as well, linked through the Project Plan. It would be helpful if the…
-
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…