-
Specifying task durations in months
This may sound like a foolish questions..... I specify my task durations in days. Can I specify some of them in months? The reason I ask is that I noticed that when I enter a duration as 6 it displays "6d" for 6 days. We have a number of tasks that have contractual commitment in 3 months. Therefore, the need to be able to…
-
Annual School Operations Calendar
Can anyone recommend a format for an annual calendar for our school operations team? What I'm trying to create is a document to input all school activities for the year and plotting each department's tasks for each job. For example: School Open Day: events showing each department's tasks to achieve effective outcome. So…
-
How do you take a list of dates and switch to calendar view?
I know about the calener button! It does not work with a list of dates in one cell, for expample: Sept 3, 4, 7, 12 when listed in a cell will not conver to the calender. thank you Charlene
-
Project with Multiple Dates and Hours
I'm working on a project that I completed over two days and want to document my hours for both days. Sometimes we work on projects over several days in different weeks. How can I enter all this data. Right now I only have one column for Date and Hours. Am I able to add more columns to enter more Dates and Hours?
-
Use Smartsheet versus Outlook to schedule meetings
I am currently using Outlook to send out meeting notices/agendas with all of the meeting attendees being members of my Smartsheet team. How can I send out meeting invites/agenda from within Smartsheet instead of using Outlook?
-
Can you sync Google Calendar to Smartsheet
Heard that Smartsheet can sync with outlook to send notifications of tasks due and add to Outlook Calendar. Is there a way to sync Smartsheet with Google Calendar?
-
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…
