-
baseline - actual dates
This post is in regards to this post below. I would like to get in touch with Jeremy michels to see if he will share the sheets he references with me.Any help will be appreciatedThanks so muchLouise Jeremy Michels601 ptsApril 5, 2015 8:30 pm I do the added columns now. We use it for both schedule and budget reasons. If you…
-
Creating a Summary View Sheet
I have a sheet which has information on Projects and Activities my team are working on across the whole of my region. If has columns such as Activity Title, Person, Region, Partner, Status This shee it great but I would like to create a linked sheet which gives me total counts for each for each Person I would like to know…
-
Critical Path During a Project
I can't seem to get my Smartsheet to re-calculate critical path after a critical path item is complete. The critical path should change as items are compeleted. What tells Snartsheet to no longer look at a completed item so it can re-calculate the new critical path during a project?
-
Nesting Formulas
I need some help with nesting formulas for the following screenshot: What I'm trying to accomplish is an automatic change in the "Status" Column based on the following criterias: 1) If "%Complete" >= 1% and "%Complete" <= 99% and "At Risk" = 0 then "Status" = In Progress 2) If "%Complete" >= 1% and "%Complete" <= 99% and…
-
moving rows upon completion of task
We want to move completed tasks within a given hierarchy to the bottom of the list allowing active tasks to "move up" Ideas?
-
Calculating output/production of resources
Hi there, I just found out that Smartsheets doesn't have a built-in way to configure the output/production for each person (resource). Has anyone figured out a hack for this? Ultimately, we run a painting company with 40 painters in the field. It is not unusual for each painter to be on more than 1 project during a given…
-
Reoccurring Event
Does anyone know how or is there a work around for entering a reoccurring event one time but have a reminder sent to you every two weeks vs enetering the event multiple times?
-
Graphic for pipeline
Hi, I am an architect and I NEED to see all the data graphically. I am looking for samples of project pipeline graphics produced using Smartsheet. Please, post them here or send me a link. Thanks! ileana
-
cost and efficiency trend calculator
I just started using smartsheets for out development firm. we have hundreds of new consturction homes that we keep seperate data sheets on everything from bidding, to actual cost, to scheduling. I would like to be able to pull the data out of each sheet and generate a report that details how much I pay for each style of…
-
Set recurring tasks, meetings
How do you easily set recurring tasks and meetings in Gantt view and Calendar? Example: Phone meeting or email updates, every 2nd and 4th week of the month?
