-
calendar view
My project management has a sheet for scheduled work. We have a color associated with each job according to who the technician is do it. Is there a way to add patterns to the lines as well to determine who is managing the job too?
-
Replicating multiple worksheets in Excel
We use an xls file to manage our monthly staff rota. I want to transfer this to SS but we use multiple worksheets, one for each month, ie one for Jan, one for Feb etc. What is the best practice for replicating this functionality on SS please? Thanks. Michael
-
Calculate % complete based upon start and end dates?
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…
-
Resource Planner with Location & Dates
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…
-
Running Multiple Projects on SS
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 to get EOM (end of month)?
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.
-
How do you create a "days remaining until start date" column that will select the start date one eac
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…
-
Changing the # of work hours in a day.
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?
-
Conditional Formatting Key or Legend
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!
-
Hello, is it possible to configure a date type column to show the time (hour:min)?
I would like to schedule activities into specific hours of the day. Thanks.
