-
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…
-
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…