-
Calculating a day from a date
I've got a column (called "Dates") formatted as dates. I would like the adjacent column to show the day of the week that date falls on. Using the formula =text((Date1), "dddd") brings back an #unparseable error in the cell. I've tried using brackets instead of parenthesis but it hasn't worked. I must be messing up the…
-
Start & Finish dates based on separate predecessors / or formula in duration
I am trying to automate my schedule for a project as much as possible. I have a line for production start that is based on my current ship date but I have 9 shipments after that and would like to have the actual production line have a start day based on the production start line and the finish date be the last ship date.…
-
Use a SS and a FF Dependency on one work item
Hi - i have weekly meetings scheduled for the duration of a ~2 yr project and I'd like to use a SS dependency from the kickoff and a FF dependency from the last work item to set the duration of the weekly meetings, is this possible?
-
Out of Office Calendar - recurrent events
We want to use Smartsheets to set up an out of office calendar for vacations, work trips, working from home etc. We are capturing name, dates, and reason for being out of the office. We planned on having staff enter in OOO on a form and then have the calendar show on a dashboard so it is easy to know if someone is out.…
-
Lookup on a form?
Hi all, Is there a way to have a date/time field on a form look up data in a separate sheet to populate itself? I'm setting up a form for people to select a date and time slot to attend a training session. I thought about having the list in a separate sheet and then only show on the form dropdown the sessions that are…
-
SmartSheet Calendar App
First off - love it. Totally has changed how we are communicating with internal project teams and external vendors. What isn't working that great: Speed - super slow to access Email Comment Notifications: it would be great if the email notifications could show the comment and thread (if any). Nice to be able to get a quick…
-
Alert or notification based on date
I am searching for way to create an notification or a reminder based on a contract's expiration date. I have checked SmartSheet's help data but have found no way to make this happen. Can anyone assist me with how to do this .... all we want to be able to have, is when a contract is within 3 months of its expiration date, a…
-
Is it possible to create a web form with appointment time bookings?
Hello, We're looking to run an event where people can meet 1:1 with an onsite consultant but want people to book a time. Does SmartSheet allow the creation of a web form where people can select from a time slot and then it no longer become available for anyone else? Thanks, Julie
-
Visually Tracking Changes
Is there a way to visually/graphically see changes to an activity "before and after" on the Gantt or calendar view? I.E. if an activity is running longer than original input is there a way to show the original end point and the added time?
-
Feature Request: Adjust Lag Time in Calendar View
I imagine this has been mentioned already, but it would be great if I could adjust lag time for tasks in the calendar view. The calendar view is great for load balancing, but it's a pain to have to go back and forth between the calendar and gantt view to adjust the dates.
