-
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…
-
Real time & ressource management
Smartsheet is a great product with great features, but it lack in crucial features for any real event and logistic planning. Add time/duration management for task When selecting a start and end date for a task, we should be able to select a time for it as well. We cannot be limited to fixed hours work day or using "gaps"…
-
Add meetings to Calendar
Hi ladies and gents, Maybe I am trying to make this just all too difficult. Can I add multiple 'meetings' with start and end times into a calendar anywhere within SS? Everything I can find that is calendar based has only 1 line, for one task input. I think I am after something similar to say, Outlook Calendar, just within…
-
Variance confusion
I have a [Start Date] and [Due Date] with Dependencies enabled. I know the dates used for the scheduling will have a time component. Other date columns do not.. I copy the data (Cntrl+C, Cntrl+V) to Baseline columns. Date component matches. I then create Variance columns where Variance_Start = [Start Date] - [Baseline…
-
Gantt report: Knowing Real progress percentage vs. Expected percentage
Hi. As is somewhat difficult to explain for me in english the requirement that I have, I'll use the google translator. I need to know if it´s possible to have by a Gantt report: -To be able to see on any given day (usually the day that I require to present a progress report works) that have real progress percentage vs.…
-
Monthly Calendar View Exportable to a PDF?
Hi there, I have a large Smartsheet document that I would like to export to a PDF. While I can export it under the card view, regular view, and gantt chart view, I cannot export it with the monthly calendar view. Is it possible to export the monthly calendar view into a PDF or Excel sheet? Thank you!
-
Possible to export a filtered Smartsheet to Outlook?
Hi there, I am new to Smartsheet and am just learning all the features it has to offer. I was wondering if it is possible to export a fiiltered grid view Smartsheet into Outlook 2013. Currently, i am able to export the entire Smartsheet to Outlook, but I want it to be tailored to only include certain events/tasks. Is it…
