-
Pull a calendar
Hi-- so, I have a series of columns representing various tasks. And then I have a series of rows representing various projects. I enter various dates into the corresponding cells (eg Project X and Task Y will occur on such and such date). What I want to do then is on a separate sheet list all of the dates in the year and…
-
the end date and the gant chart date is not matching
Any body has a problem similar to this: I set the end date at 2018, but the gantt chart showing a 2019 ?
-
Using Today formula in date field has limitations
Hi. I just wanted to find out if perhaps the =today() function does not work when using a sheet with begin and end dates and dependencies enabled. When I try to enter the function, it only shows the actual function statement and not today's date. However when I use this function on a sheet with only one due date column and…
-
cell reference based on date
We have a yearly schedule for all our field guys that is updated a week prior and sent out to the field so everyone knows where they will be working for the upcoming week. My question is can I tie a roll up sheet to the master schedule sheet that I would input a date on the roll up and based on that date grab the matching…
-
Feature request: company holiday management in Workspace
Hi there, I've seen some discussion on these boards about managing non-working time. It seems there's two out-of-the-box options, either to have each individual project manage their time or have a sysadmin do it at a global level. Some have suggested blocking time using a dedicated gannt chart. For larger companies across…
-
Small Business people out there?
Hey, Just starting with Smart Sheet I am looking for anyone who manages a small business with lots of tasks for some tips on better time management
-
Printing Calendar View - Remove Weekends
Is there a way to remove the weekends when printing from Calendar View? I know that a text wrap feature isn't available and the titles of events get truncated. Perhaps if we could remove the weekends from printing, the event titles would have a little more space to display.
-
Predicting a Date based on what type in as I complete a step
The first column are the dates I complete a task. The fourth column are how many days I have to complete the task. I'm trying to predict the completion date as I enter the dates in the first column. The expected completion date will move up or down depending whether or not I finish the task on time or a few days earlier.…
-
Conditional formatting calendar in cell.
Hi, is there a way to set a minimum date in a drop down calendar in each cell? In my case I have a calendar drop down in a cell where my user can select a date to be completed. However, I would like to set the available dates to no less than 2 weeks. Hope that makes sense.
-
Publish Calendar to display working days only
I have a project that covers 3 months with 4 people traveling to various offices. My calendar indicates their locations throughout the months. I've defined Working Days, Non-working Days, and Holidays on a Project Sheet, which reflects correctly. However the calendar view indicates that the persons are in the locations…
