-
Import calendar into Lotus Notes
My organization uses Lotus Notes and I need to be able to sync the Lotus Notes calendar with smart sheet but have not been able to find any information on how to do that.
-
function dates difference
Hello there! I am trying the function =TODAY() - [starting date]3 and I am receiving this number as result: 86.7854 how can I obtain jus a round number of days?
-
% Complete and Durations
* Hi, I am a recent user of SmartSheet and was unable to find an answer in any of the current help venues. My apologies if this is duplicated elsewhere. Here is the situation I am facing: - I have a task with a two day duration. Let's say it was set to complete yesterday. - Today, I am told that the task is only 50%…
-
Virtual Time Cards - Contractors Working Remotely - Timecards
We manage a group of independent contractors that work off site. We are looking for a design of a web form so they can record the hours worked daily. This would have to allow for start time, lunch time (punch out), lunch time (punch in), and end time. Looking for a formula to calculate the hours worked daily, weekly, and…
-
Setting start date for Calendar
Hi, I've just started using Smartsheet so hoping it will do all the things I need. My chart calendar starts in September 2014 even though all the things on my chart are from March 2015, how do I fix this, I don't want to have to move the bar along every time thanks Karen
-
Looking for input
I am new to SS. Looking to see if the following scenario is do-able: We are a small catering company, where interdepartmental communication is not consistently accurate enough for the volume we are capable of producing. SO, if I have (for ex.) 6 events in one day, 2 at lunch and 4 at dinner time, I need the prep guys to…
-
Synching multiple items per day to Google Calendar
Hello, My company tracks vacation/personal days using Smartsheet. We export to Google Calendars which is what we use for most event/meeting planning. The problem I'm having is that when more than three people take the same day off, only three of the people show up on the Google Calendar. Its only happened a few times but…
-
Setting date ranges with start-date to start-date and end-date to end-date dependencies
I have a project where I am setting a range of production dates and want the sheet to auto-update if I update that there is slippage in the timeline to see how far out things push. It is easy to schedule dependencies on the front end. For example - if I have items: 1. PO to readiness of raw materials is 2 weeks from the PO…
-
Filter Calendar View?
Is there a way to filter the Calendar view WITHOUT having to switch back to the grid view?
-
Enhancement Request: Choosing which task to display on Agenda
Hi, A great way to improve your existing features regarding Sync with Google Agenda (or even the regular Agenda view) would be to allow the user to check or uncheck the tasks he wants to be synced, and the ones he doesn't. I use a lot of titles or categories for my tasks and subtasks but most of the time they are…
