-
How can I change the WBS phase number for my WBS by phase?
Hello, I am trying to figure out how to change the WBS phase number for specific tasks in my project. For some reason a group of about 15 tasks is assigned to phase 1 in my WBS, but they should be phase 10. The WBS number is showing 10.1, 10.2, 10.3, 10.4 and so on, but the phases for these are locked in. How can I assign…
-
Dynamic dropdowns - Waterfall request
The Contact List, Dropdown (Single Select), and Dropdown (Multi Select), are useful tools to control data entry. The problem is they require a lot of maintenance. Through Bridges, we have a sheet that is populated with information from our ADP. It contains all of our employees. Using a Contact List column and selecting the…
-
Custom Colors for Sheets
While it is wonderful that we now have the ability for custom colors on Dashboards, it would be truly helpful to also have this same ability in Sheets. It would be really helpful for some of our projects because our district uses certain colors to call attention to various district initiatives or our district instructional…
-
Primary Column Options
I am sure this has been said before but I would love the ability to expand the primary column choices from just text to also date columns. This would be really helpful for us folks in manufacturing when it comes to daily metrics.
-
Extract name from Team Column
I have a form where a user identifies all the people from different departments and input their names in the Team Column. There are times when people are not filling it out for various reasons (wasn't part of the team, forgot by the team member or the original created by user, etc..). I want to be able to check if the…
-
Filter for rows that are due to day and in the past
I want to be able to filter a sheet to show the rows that are due to today and any that are overdue, i.e. in the past. i have a column called due date and another called status which is either started or complete. the filter i have on is 'status = started' and 'due date = today' . however i would want to filter on 'due…
-
Projektfortschritt innerhalb der letzten 30 Tage
Auf einem Projektplan wird mir der Erfüllungsgrad des Vorhabens durch die Abhängigkeitseinstellungen (Start/Ende/Erfüllungsgrad) wiedergegeben. Auf einem Projektedashboard möchte ich gerne tagesaktuell, jeweils die zurückliegenden 30Tage betrachten und für diesen Zeitraum (Datum heute/-30 Tage) den %tualen Fortschritt…
-
How would you measure progress by quarter
Hi there, I am hoping to crowdsource some creative answers to a question that has been asked of me by my leadership team. I currently have a Project Management Office/Organization set up in Smartsheet where projects come in with a request form and are managed on an intake sheet, get their own project planning grid &…
-
Give Administrators full vision and access to all sheets
I recently contacted support about this and was amazed to find that what I thought would be a simple function doesn't exist. We have had staff leave recently and not so recently and have had requests from senior management to look for data that they may have stored in sheets that they may of owned or shared or transferred…
-
Can Bridge get data from Admin > Groups?
Is there a known or suggested method or Bridge workflow I may use to record data from Admin Center > Groups to a Smartsheet? I want a workflow to look up the groups in our plan's Admin Center and replace the rows of a sheet and column on a daily recurrence.