-
Duration calculation issue
I don't know if it is bug or feature, but it looks strange for me. So I have sheet created based on project template. I have dependency turned on. I noticed next behaviour: If task start at weekend or holiday then duration calculated with one extra day. On attached image all tasks (except task2) have wrong value in…
-
Date Format yyyy-mm-dd
Hi all. I've found the numerous help articles describing the Date Format being controlled by your \Account\Personal Settings\Language (Country)\ selection, but as far as I can tell all formats are mm/dd/yy or dd/mm/yy. I need to format in the ISO standard of yyyy-mm-dd. Has anybody successfully found a way or implemented a…
-
Date Formula in a Gantt Chart Cell
I have tried to add formulas in the start date column for a gantt chart that reference a base start date cell and add a certain number of days to the start date. Is that possible? Example of the formula I am implimenting: = StarteDate + 10 The gantt chart start and end date columns use the Date/Time type of cell and Date…
-
Feature Request - Pattern Overlay on Gantt bars
It'd be handy to be able to add a pattern overlay to Gantt bars. Like these: http://www.webdesigndev.com/wp-content/uploads/2015/02/20-Repeatable-Pixel-Patterns.jpg The use case for us is that we want to color code our bars for who the'yre assigned to, but be able to label some of those bars as having a "fuzzy" deliverable…
-
Using smartsheet for grant writing
I am a grant writer at a nonprofit and my development team uses smartsheet. I am at the beginning stages of using smartsheet and want to use it for EVERYTHING related to my grant writing (calendar, deadline tracker/notifier, links to emails, links to webpages, task list, grant applications, anything else you can think…
-
Why does moving a subtask or milestone in the Gantt view preserve durations...
but rekeying an end date alters the durations? I'm using predecessors and start-to-finish dependency to work backwards from a deadline for a task. The durations for subtasks must remain fixed. If I type in a new deadline for the task, the durations adjust—this is not what I want. If I slide the deadline in the Gantt view,…
-
Gantt Chart - Shading after Finish Date to include actual deadline
I'm wondering if I can also use the Gantt chart to identify when we were timely on actions. For example, now it will show a bar correlating with the Start and Finish times. I'm using these as planned start and due dates. If the deliverable was sent after the Finish time, is it possible to have the Gantt chart linked to a…
-
Change Gantt Chart Quarter headings
I am trying to change the Calendar Quarter Headings in Gantt view to reflect our company Fiscal Year Headings. Is this possible? Best, Kat
-
dealing with distant dates
Hi everyone, I really need help here. My project is of the long sort (several years). I seem to have a problem with far away dates: smartsheet won't 'take' a date in 2018 (I type it or select it in the calender and the box goes blank). My other question is: how do I hides dates (I don't need the next few months on the…
-
when adding a new event to construction spreadsheet start date will not change
i have add some rows to a certain stage in the construction process, however with each new event i add the start date always goes back to the construction start date no matter if i change it on the calendar function or type the date in please help i am using a gantt chart to plot this project out