-
Autonumber refresh for new year
I use a formatted autonumber column to record a new Reference Number for each new entry in a Smartsheet. The format I use is CR{YY}.000 where 000 started from 001 for the year 2016. I want to continue this format into 2017, but I want the 000 to restart from 001. Any thoughts ? My list of rows should end up like : CR16.001…
-
Merging MS Project information into SmartSheet Project
I manage a number of projects using SmartSheet for my company. We employ multiple subcontractors and vendors on these projects who use MS Project to manage their activity, but we report on the aggregate project inside our company with SmartSheet. I receive regular (weekly), updated MSP files from the subcontractors, and…
-
Hiding data in my project plan for specific users
Hi, I read related smartsheet discussions on this. Is there a solution for this other than hiding the columns which contains the info you do not want to share with other users? I have budget figures on my project plan, and only 3/8 users are allowed to see it. I know you can create a seperate sheet and insert links. But…
-
Can Smartsheet show a Gantt style bar that shows monthly RAG status trend?
I am new to Smartsheet and have a POC developed in Excel that allows us to have a gantt style timeline that is coloured by month according to the monthly RAG status. This RAG status is conditionally formatted based on whether we indicate 1, 2 or 0 in the cell but is not shown. We can also add activity descriptions in the…
-
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…
