-
Using Calendar Days but, not including weekends or holidays for my end dates.
I believe that I may have asked this in the past but, in the legal profession we use calendar days for calculating dates but, do not want the completion dates for most tasks to fall on a weekend or holiday. Any solution to this? I came up with some fancy formulas to do this but, because Smartsheet uses its calculated date…
-
How to set up a departmental time off request sheet?
I was wondering how I could set up a document that is one sheet for time off. The main things we need are a form or something to fill out that will go to the employees specific manager to approve or deny, and will then notify the employee if it has been denied or approved, and if approved, will then populate in the sheet…
-
Calendar view in iPad
Is there a way to see the "calendar view" on an iPad? It looks like there is only grid, list and gantt view. We have a gantt chart we are trying to use to manage projects but our tech in the field need to to able to see the projects on a calendar on their tablets from the field. We can sync with iCal but then the colors of…
-
Webform calendar question!
I'm a brand new user so please, be patient I created a very simple webform to send to employees to pick dates they could work a certain event. HOW, once the date is no longer available can it be removed as a choice? Any and all help would be so appreciated! Thanks
-
Date created as start date in Calendar range
Hello, I'm trying to use the system generated creation date as a start date for a range in calendar view. For some reason it's not recognizing the column as a "date" column? Any ideas on how to make that work? Thanks. - Eric
-
I would like to hire an experienced consultant
I am relatively new to Smartsheet. I need someone to help setup Smartsheet to manage our book production schedule. We publish books (print and e-) and have managed our production schedule for many years with a Google Sheet. It is severely lacking. I have not yet signed up for any plan. I don't think I'll need 3 licensed…
-
Card View: Date, Gantt & Swimlane updating
I have an 8 week dev project. Each Dev is prioritised to fit in a chosen week (week column/Lookup). Then a nested if formula populates the start date of that week (if week 1 then, if week 2 then....etc). This allows my card view to present a date and the week, which can dynamically update as I drag the card. BUT I would…
-
Separating weekdays from weekends
Hi everyone, this is probably something very simple, but I still struggle, hope you can help. I have a large timesheet with one raw per day, every day of the year. The contractors will get paid higher rates on weekends, compared to work days. Initially I thought of putting an extra checkbox "weekend" column next to the…
-
Calculating a Due Date
Frequently in legal transactions a transaction closing date may depend on the outcome of a couple or more previouls tasks. It will be the later of two or more previous tasks. Each task's completion date plus a different number of days depending on the task. The answer is the latest plus another specified number of days.…
-
Multiple Duration columns (or a way to calculate number of day between two date columns)
I'm trying to setup a sheet for tracking actual work dates vs target dates Construction Document set timing. In each deliverable/row I'd like to list the following dates: • Target Date * • Act Start * • Act Finish * • Approval Date I have my the project settings turned on so that "Act Start" and "Act Finish" create teh…
