-
Reporting from multiple sheets
Is there a way I can run a report from multiple sheets? I can select 2 or more sheets but it's an "OR" and not "AND". So, the report isn't reporting on all selected sheets. Or, am I missing something? Thanks!
-
Formula Referencing Cell Populated by a Formula
Thank you in advance! John
-
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
