-
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…
-
Setting up automatic reminder system
Hello community, I have a tricky question here concerning how to send out a reminder automatically based on the following idea. I have a sheet which lists the status of certain rows. Each row has a column that indicates with Green/Yellow/Red/Gray dots (symbols) - these indicate if an item has been fixed, pending, still…