I'm trying to put together a Gantt chart with a generic timeline (i.e., Month 1, Month 2; Week 1, Week 2, etc.) rather than actual dates. Is there any way to do this in Smartsheet?
In MS Project I often used subprojects and could easily reference them in one row of the WBS. So, I looked for instructions on how to do this and the most relevant hit suggested that "phases" be used.…
How would I write a formula to automatically populate a status column with red, yellow, or green based on where the project is at? In the screen shot below the Implement Asset Works is on-track becaus…
Hello, I am wondering if there is a way in Smartsheet to version control the sheets. Basically, we are using each sheet as an individual project plan. However, as projects progress, the plan will (usu…
We are tracking Open Enrollment for several clients in two major categories - MED and FLEX - with tasks necessary for each. In the screenshot, the percentage for the client at the top is rolling up, b…
I trying hard code the start of a sub-task (4th level indent). When I try the start dates always comes back to the start date of the task of the previous indent. I would like to have my sub-task with …
Hi guys, Struggling with what I assume is a easy fix. The dotted line that represents 'today' is showing to be out by 1 day. I.e, it is Tuesday here, however the dotted line is showing Monday. I have …
Hello Smartsheet community, I am wondering if there's any way to default your view setting to Gantt (or others) when you created a new blank sheet? I want to avoid changing the view setting every time…
Hi All, I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multi…
Hi, Pretty long project, spanning a bit over a year. I'm about halfway through it & the Gannt Dates started getting weird. In the image, Look at "Floors", predecessor 232. The scheduled start date col…