If I have a task that can only happen on a Tuesday (e.g. that's when an approval committee meets), and all the predecessors are scheduled to complete the previous Thursday, how do I schedule the task to start on the first Tuesday after the predecessor completes?
I'm creating a sheet summary report to use for a dashboard and have my source data broken out by phases. I'd like to be able to group the report data by phase, so I tried adding a single selection dropdown to the sheet summary. However, it's returning blank in the report. The source data is a project management / Gantt…
I am trying to create a Smartsheet to track project completion (Integration) for my company and am running into multiple hurdles with the reporting. I'd love to hear your insight on how to overcome these issues without having to turn off all dependencies. Without dependencies the product doesn't offer much for project…
一个列有颜色的能力不是row to show for example UK bank holidays or staff holidays etc.. to show in a very quick visual way any clashes that might be avoided.
We use a separate gantt timeline for every project. We also use a simple grid to capture to-do tasks not relating to any specific project. We want to be able to view all cards from all projects, on one kanban board, to get an overarching view of everything going on. Can someone please tell me a simple way to do this?…
Has there been an update to allow color edit to the gantt chart parent row bars? Thanks - Julie
I have two dates: A and B. B's start is dependent on A's completion. If everything goes as planned, A will finish on 2/27 and B will start on 4/1. B's start date is constant unless A's finish is delayed beyond the planned start. For example, if A is delayed until 3/15, B will still start on 4/1; but if A is delayed until…
On a Gantt chart, I've added a column % Progress Expected and I have it calculating % progress expected per day for each line item, based on the duration; see formula below. =(TODAY() - Start@row) * ([ADMIN: % EXPECTED DAILY PROGRESS]@row) * 1.1 The problem I'm trying to solve for is I need it to show 0% progress expected…
Hi, I'm new in Smartsheet coming from the MS Project world. I'm trying to include the % of task completion in a gantt chart. I'm filling in the % complete column but nothing appears on the gannt chart (contrary to what is described in…
Hi All, I'm working on automating a symbol highlighter to indicate project progress as well as alerting if key milestones are being compromised. The formula below is structured based on the following columns: * Finish: The Activity completion date * Start: The activity start date * Date: A column containing fixed dates to…
