-
Use of one sheet as List for other Smartsheet
I am trying to select Project names in my action tracker smartsheet. The Project names has been maintained as separate Smartsheet. How to link Project name sheet as List in my action tracker sheet.
-
Calculate due date based on start date + either 1 or 5 days
I need to calculate a investigation date which would be 5 days, unless the "foodborne Illness" cell is checked, inwhich case the investigation date is 1 day after the complaint date. This is for a complaint log I am putting together. I want to auto populate the deadline for the inspector to initiate the investigation. I…
-
Using Gant chart in Powerpoint
I have a request to display the gant chart for a project within a powerpoint presentation. When I export the plan to an image, it appears pretty small and grainy. I would love to pick and choose some rows (I have already collapsed as many as I can) to display to see if the size would be better for the powerpoint slide but…
-
Staff Time Sheet
Does anyone have a staff time sheet template they would be willing to share? Although I am really enjoying Smartsheet, I am not figuring out the calculations and just want a time sheet for employees, time in, time out, regular hours per date, sick, PTO, holiday, OT and total for week. I would sure appreciate it if someone…
-
Calendar Day Settings
Is it possible to make individual lines 'Calendar Days' rather than working days? - I have investigated into the project settings and it appears that the calendar dates can only be amended if it changes the whole project? Any advice would be much appreciated.
-
Conversion Formulas / Cell Linking
I am cell-linking 2 sheets but 1 sheet records time in days and allocation: Example: 2 days and 50% Allocation = total of 8 hours spent on the project over the course of 2 days. (The duration can not be changed from days because this is our project management sheet and we use in the gantt chart to share with customers.)…
-
Setting a print area or range
It would be helpful to be able to set a print range or area for sheets that are very wide and/or long.
-
Duration Logic on Start Column
Is there any logic that is not obvious running behind the scenes on the "Duration" column that affects the "Start Date"? See picture below. On Training Day 18 deliverable, each task is taking 0.25h and the rolled-up total is 0.156d. Why row 368 is pushed to the next day ("3/22/2017") if all tasks above it are less than 8…
-
How do I create a report that groups different sheet data by week, then ordered by date?
We have separate sheets for our different editorial teams -- like this: - TASK 2 (from team 2's sheet) - TASK 3 (from team 2's sheet) - TASK 4 (from team 2's sheet) thanks superheroes! m
-
Roll-up distinct selections in dropdown to parent row
Is there a way to roll-up child dropdown selections to the parent row so that the selections show only once in the parent? Example: Dropdown contains: Red, Blue, Yellow Child 1 selects Red Child 2 selects Yellow Child 3 selects Red I found where I can use JOIN(Children()), but this will display Red, Yellow, Red in the…
