-
How to show more than one month on calendar view
I am wondering if there is a way to show more than one month on calendar view. I am working creating an HR sheet and I need to be able to see the last 12 months if someone took a vacation. Also is there a way in a column to have more than 1 date so for example if someone took off both June 5th and then July 8 can we put…
-
Film, Commercial or Television Project Management/Schedules template?
Is anyone using Smart sheet for there TV series, Commercials, Film projects? Looking for a template that covers Project development , Project Greenlight, pre production, shooting schedule, edit/post schedule... Looking for somethiing that will manage production scedule and producers/editors. Before I build it I thought I'd…
-
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.…