Hello, does anyone know how to calcuate the % complete for a project based upon it start and end date? I have projects where my resources are "consulting" and I'd like to have a way to see the % complete of the project when I roll it up in a project overview dashboard. I tried using the traditional "yearfrac" formula…
Dear All, has anyone created a resource planner that shows day by day location such as onsite, offsite, vacation, public holiday etc.? I would like for two columns with the resource name and the resource role and then the rest of the columns should be the calendar with the column showing the day and date for the month. An…
Hey SS Community, I am involved with a company that currently has no central data base overviewing all projects. I want to put a system in place where the PMs can manage their own projects. Also a system where the sales, quoting and other teams can oversee how the projects unfold throughout the project life cycle. I…
How do I get the EOM (end of month) if my start date is 10/07/2016 ? I'm new and having some trouble with this. Thanks.
Hello! I'm new to Smarsheet and haven't been able to figure this one out. I have a sheet with many tasks that have different start and end dates. I want to create a column that will tell me how many days are left until the start date of each task. This formula works: =[Start Date]23 - TODAY() But I need it to automatically…
Should changing the hours in a day update the project schedule? For example, if the plan/scheudle is finished and based upon an 8 hour work day - shouldnt changing the work day in the project settings to 10 hours a day change the project schedule?
We use conditional formatting for our master training calendar to show which training is for which audience. I have been asked to provide a "key" that shows what each of the colors represents on the calendar, but I haven't been able to find an easy way to do this. Any ideas are welcome and appreciated!
I would like to schedule activities into specific hours of the day. Thanks.
Tried searching but to no avail. Any updates or plans for calendar view for android app? I do see that calendar view is available for iphone users.
Is there a smartsheet timeline for implementing the gantt chart "zoom in" to see hours/minutes of a day? I have been tasked to figure out a 24/7 schedule for 3 crews and would love to see the gantt chart reflect actual change over time....cross over...lag etc.. Also are there any plans to update the printing capabilities…