-
Gantt Chart timeline issue
Hi there, When I try to print a Gantt Chart the timeline is in, say, months or quarters, but when I press the printer icon it automatically converts to a weekly timeline. Does anyone know how to control the timeline when I print? Thanks, Paul
-
Resource Mgt
Im new to this. If we have one resource alloocated over several sheets and in one sheet/project the resource is required for an extra day, How do we link so that all associated sheets dates are updated? thanks
-
Creating a new template
I just moved my team over to smartsheet (off of excel), so I'm still learning. Is there a way to create a new template with custom columns so that my team can have a consistent custom template to start projects with?
-
IF/AND Functions
I am trying to create a sheet that will auto update a number in a cell using multiple IF AND statements. Is it possible to have multiple IF(AND statements in one cell or what is the format? When I have one statement it works properly, but I cannot figure out how to have it work with two or more. I am not worried about the…
-
Multiple Projects - all with interlocking critical paths
Hello community I don't know if anyone else has this issue. I have multiple projects, resources etc, that all overlap. I have a VP that wants to see the critical path over ALL of the projects. Is there a way to do this? I know we have critical path capabilities within one sheet, but i dont see it in a report when i put…
-
sign-in sheet/roster
I’ve been tasked w/ creating a sign-in sheet/roster tracking when and how often volunteers are volunteering. Looking to have either one person manages or have individual volunteers sign-in and mark off. Would like fields: Full Name, Function, Date, Time-In and Time-Out – and have the ability to sort by volunteer name or…
-
Need Some Help Nesting IF Statements
Hi everyone, I am trying to use End Date, Duration, and % Complete to calculate the correct color ball in the status column and I am having trouble combining the statements I believe I need (might be wrong with my basic statements also). Here is my thinking: Red – if you are at OR past the end date AND not 100% complete…
-
Specifying task durations in months
This may sound like a foolish questions..... I specify my task durations in days. Can I specify some of them in months? The reason I ask is that I noticed that when I enter a duration as 6 it displays "6d" for 6 days. We have a number of tasks that have contractual commitment in 3 months. Therefore, the need to be able to…
-
Percent Complete by Cell Color
Is there a formula to determine percent complete of a task based on the cell color? Cells are filled with dates of various steps in a project and once those are completed, the cell is highlighted. I'd like to have the percent complete column update automatically when the cell color is changed. Help, please!
-
URL direct into Card View....or make card view the primary view?
I have a lot of team members who struggle with new tools. The card view is VERY easy for my team to navigate and quickly shift items around. The problem is that the link I provide for them to access the Smartsheet always defaults to the standard spreadsheet view. I get calls of confusion because they forget how to toggle…
