-
Sum hours from multiple sheets based on date ranges
I'm looking to determine how many hours are assigned to specific stage for a given week. Goal being I have "X" number of man hours available for a given week and if I've assigned 300% of that this week but 25% of it next week I need to know I've got shift resources or tasks around. I've got report that shows me all the…
-
advancing dates (roll over)
I have a number of simple tasks that re-occur regularly. Is there an easy way to roll due dates over monthly, quarterly, or yearly?
-
Create Gantt from End to Start
Hello! As a project manager, I often find myself needing to make timelines starting with my end date. However, I have only been able to make Gantt charts in Smarsheet (with dependencies) that I can change the very first start date and then the durations, but I can't work backwards or change start dates to meet my needs! Is…
-
Multiple calendar dates in single row
I have a production schedule that list the issue in the primary column and then column headings with due dates for several items throughout the production process. I'd like to show all dates in each column individually and not with a start/end date. I lose the detail in the middle. Possible? thanks Donna
-
Calendar calculation (possible bug)
I am having difficulty with a calendar calculation that I use to calculate planned completion %. When dates have more than 30 days or when a non-working (holiday) is part of the month, the formula is not working as intended. Below is the formula in the planned % complete column: =IF([Planned Finish]4 = TODAY(), 1,…
-
View today, including one day and multi-day items on sheet
We track all our promos on one sheet. Some of them run one day, some of them run for several days, some of them run more or less permanently. I need a view of everything running on a given day. The filters do not appear to permit this. Any ideas? Ideally, would like this to run in calendar and gantt views. Alternately, is…
-
Possible to create Gantt Chart in duration of "hours" for single-day projects?
Hi, I created a project smartsheet with gantt dependencies in duration of "hours" for an important project that lasts one day. I was wondering if there is a way to create a gantt chart that only displays one day but shows durations of "hours" on the x-axis instead? (The current gantt chart I see only displays 30 days…
-
Sync Smartsheet calendar to Outlook - help troubleshooting issue please
Hi everyone, thanks to the useful posts here, I was able to sync the Smartsheet Calendar to Outlook, but no events show up in Outlook. I am pretty new to Smartsheet, so not sure what information you might need to help me troubleshoot. Can anyone help please? Thanks, Patrick Here are two screenshots, showing Smartsheet and…
-
Creating and editing schedules in Calendar View
Hi all, I am just wondering if there is a way to visually create and edit a schedule in Calendar view. Such as dragging dates and durations like we do with Gantt bars? Darin Schnitzer
-
modify titles in calendar view
I really like the Card view and how you can show different fields or parents of things in the description. I would very much like this to be added to the calendar view. Defaulting to the primary column is very frustrating IMO and makes the calendar functionality almost useless for project management IMHO.