-
Unlock enhanced team efficiency with board view—now generally available!
Hi Community, We're SO excited to announce that board view – the agile-for-everyone solution from Smartsheet is now available. From managing Agile sprints to marketing campaign calendars and beyond, board view streamlines project tracking with a visual layout that keeps teams on the same page as work items progress. Board…
-
How To Have Risk Column Automatically Update Based On Certain Conditions
Hello, Can anyone help me write a formula based on the following conditions. Risk Status = "Green" if the following conditions are met: [Delivery Confirmed] is checked Risk Status = "Gray" if the following conditions are met: [Release Date] is Blank Risk Status = "Red" if any of the following conditions are met below:…
-
How can I add a widget to show overall project health, pulling data from a Master Timeline?
Hello, I am trying to add a widget to my dashboard to show the overall Health of a project. I already have a health column in the sheet I will be referencing, and I have added a chart to the dashboard showing the individual tasks and their Health, but I want to add a widget (please see below what I am looking for) based on…
-
Include predecessor references with copy to another sheet
Sorry if this is already in the forum. I searched and did not see it submitted as an idea. It only comes up in other discussions. Issue: When using copy to another sheet, the rows do not maintain their predecessor references. Use Case: We utilize Control Center to provision our projects from a standard "PROJECT TEMPLATE".…
-
Constraint Types in Gantt View
Requesting the ability to use constraint types in a project (Gantt view), similar to the options in MS Project: As Late as Possible As Soon as Possible Finish No Earlier Than Finish No Later Than Must Finish On Must Start On Start No Earlier Than Start No Later Than
-
Automatically populate "Duration" column
Hi all, I have a task tracking sheet, with each task having a start date, an end date, and a duration. I need the end date field to be populated based on the start date and the duration, so I set the dependencies and date range display accordingly on project settings. However, the duration of each task must be calculated…
-
Real Estate Project Management
Hello, is anyone working with a real estate/construction project management template dashboard that they have found helpful? We are a project management firm and we are having trouble finding dashboards that meet our needs.
-
Merged: Add Column Type 'Time' in 12 & 24 hour format please
This discussion has been merged.
-
HELP - Creating dependencies but using start-date instead of lag
I am building a plan with my stakeholders, we have a number of sprint-based tasks that have dependencies. It is very painful to constantly use the 'lag' function for all of these. How can I:1. Link activities using dependencies so they can be visualised in the plan. 2. Allow me to put in a start-date for the successor…
