- 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…
- 为什么移动子任务或里程碑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
- % Complete column can only be updated manually?
Is it true that a % Complete column for a gantt chart can only be updated manually? It would be beautiful if I could use a formula which would update it automatically.
- Dependency Settings
i am trying to build a construction timeline for a project. and i need to use different dependency time frames for different vendors in the same spreadsheet. for example: Permitting works on a business work week schedule. so Mon-Fri no weekends and no holidays. However the GC has agreed he wiil complete his work in exactly…
- Work on days not normally a work day.
Is there a way to work on days not normally a workday, ex. work on one saturday. So a 2 day job can be set on friday and saturday, without changing the whole calender of workdays?
- Highlight a column on the calendar (Gantt)
Currently I have the ability to manually add holidays to the Gantt view, which default as non-working days. I would like to be able to mark a calendar das a WORKING or NORMAL day, but still have it highlighted (in a color of my choice) on the Gantt view. Ideally, I could even add a description that would show if I move my…
