-
Smartsheet - Procore & Cyberco Sync
We just started creating schedules in Smartsheet and are trying to sync them to Procore via Cyberco and running into issues. Cyberco's site is vague with little in ways support material. Would love to hear some experiences / input on this subject.
-
Generic timeline on Gantt chart
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?
-
How to add phases (or use sub projects)
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. However, the help instructions are either wrong or I am not interpreting them correctly. The instructions say to add a…
-
Formula for project status based on where a project is at
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 because the gantt bar is filled in to the dotted line. The Implement Salesforce is behind schedule since the gantt bar is only…
-
Version Control of Project Plans/Sheets?
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 (usually) slip and/or have to be updated, so we need to amend it. Since there seems to be no way in Smartsheet to baseline the…
-
Percent Rollup Working Inconsistently
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, but the the bottom is not. Is this because the first item has a duration of ZERO? I would still think marking it as 100%…
-
Trying to fix the start date of a subtask with no dependency
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 no dependency to start much later (hard code the start date). Any suggestions? Thanks
-
Wrong Date line
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 been into user settings and ensured that the Time Zone and Regional Preferences are correct however still cant get it to…
-
How to default your view setting
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 my team and I are going into the sheet. Thank You!
-
Volunteer Allocation
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 multiple cities in 20-50 specific locations (we do not know these specific locations until last minute). I have built a survey…
