- Calendar Day Settings
Is it possible to make individual lines 'Calendar Days' rather than working days? - I have investigated into the project settings and it appears that the calendar dates can only be amended if it changes the whole project? Any advice would be much appreciated.
- Conversion Formulas / Cell Linking
I am cell-linking 2 sheets but 1 sheet records time in days and allocation: Example: 2 days and 50% Allocation = total of 8 hours spent on the project over the course of 2 days. (The duration can not be changed from days because this is our project management sheet and we use in the gantt chart to share with customers.)…
- No API access to Gantt Fields?
I see in the API documentation that the programatic access of row data in columns of type Predecessor, Duration, etc. is not supported. I'm doing what I've seen many others on this forum try to do; I'm merging several interdependent sheets into one "master" sheet. It need only be a snapshot of the others and needn't…
- Merging MS Project information into SmartSheet Project
I manage a number of projects using SmartSheet for my company. We employ multiple subcontractors and vendors on these projects who use MS Project to manage their activity, but we report on the aggregate project inside our company with SmartSheet. I receive regular (weekly), updated MSP files from the subcontractors, and…
- Can Smartsheet show a Gantt style bar that shows monthly RAG status trend?
I am new to Smartsheet and have a POC developed in Excel that allows us to have a gantt style timeline that is coloured by month according to the monthly RAG status. This RAG status is conditionally formatted based on whether we indicate 1, 2 or 0 in the cell but is not shown. We can also add activity descriptions in the…
- Highlight critical path
I have just started trying to use Smartsheet for project planning. I have created a Gantt chart for my project, and entered dependencies, durations and resources. However, I haven't yet found a way of highlighing the critical path. When managing a project, it is useful to have the tasks and the dependencies that are…
- gant bar color
你好,我是迫切希望我如何can change the color of a gantt bar. Right clicking on it .. only shows me "edit" option .. but not "color" option. conditional formating : If I select to apply a color to the whole line .. then it allows me to indicate also the gantt bar color .. . If I select eg red .. it doesn't…
- Multiple Projects - all with interlocking critical paths
Hello community I don't know if anyone else has this issue. I have multiple projects, resources etc, that all overlap. I have a VP that wants to see the critical path over ALL of the projects. Is there a way to do this? I know we have critical path capabilities within one sheet, but i dont see it in a report when i put…
- % Complete column is missing
I have created a project that seems to be working OK. I just noticed the % complete column is missing. It's quite possible that I deleted it without recognizing its significance - don't really know. How do I re-insert it. I have looked at the column insertion options and don't see it there.
- Gantt Chart - Show Repeat activity every fortnight / month etc
Hi All I am wanting to show an activity that needs to happen every week or month on a Gantt chart in one row. Any suggestions please?
