-
Difficulty with number vs text format, especially when using primary column as match range
Currently I have a primary column in sheet 1 which is a value of 3 digits, all of which are numbers. These numbers are generated by the auto-number column type. I attempt to use this primary column as a match range to pull information with an index & match into sheet 2. Performing a test using ISTEXT on sheet 1, all…
-
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
-
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…
-
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…