-
How can I see a dashboard of all my projects - from Home Page?
Is there dashboard view for all my projects? Something that launches as Home Page?
-
Excel template that generates (automatically) formulas for smartsheet
Hi Guys, I made an excel (macro enabled) that allows to my team create projects easily and faster. The file generates (automatically) formulas for smartsheet. I publish the example here You can register time here This is the video The video is in spanish, I will translate it in the coming days. Regards, Álvaro
-
Conditional formatting for columns, informed by row-level input.
Hi all I am building a template for which the top row has date columns set up so that all date columns change color based on the date (today/tomorrow/yesterday). The first 2 date columns are, Start Date, End Date, and are not the concern. The remaining date columns, Milestone 1, Milestone 2, etc, are dates which are pulled…
-
When will Smartsheet be able to produce comprehensive reports and link Gants charts into WBS's?
I'm an advocate of the intuitiveness of smartsheet and use this programme over other PM software for gant chart use. I find it is more user friendly, easier for collaborative use and the fact I can use this on all platforms. My question is, why does smartsheet not have the ability to produce WBS and comprehensive reports…
-
Can I build a resource pool to choose from for multiple projects?
Is there a way to build a data base of human resources (assigned to) that I could choose from when working within multiple projects? Is there a way to indicated allocation % of that resource so I can understand if certain resources are being over-allocated or under-allocated?
-
Formula help...
I've tried a formula that seems to work, in that it doesn't give me the lovely "Unparseable" or "Missing Operator" message. Here's the scenario: If Column A (text column) contains "These words" then Column D (date column) = Column B (date column). Column A does contains the needed words, and Column B is a date. But Column…
-
Graphical display of the indent level
One feature I really feel the need of is the possibility to have graphical display of the indent level of the rows. Since I'm working with big files of data, sometimes I don't have the father row and the children ones (which have been indented) on screen, but I have to scroll the sheet. When working with multiple levels of…
-
Mechanize Alerts?
I'm linking cells between two sheets A and B. When my project manager changes a row's start or end date in their sheet A that links to my sheet B, can I have an alert triggered by this change to notify me via email? Is there a better way to achieve this type of mechanization? Another way said, once my PM is done with a…
-
Row Level reminders (over allocation)
Does anybody have experience with a report showing over allocated persons in a project? What I mean is when person A works in project X on day 1,2,3 and 4. And the same person A is working in project Y on day 2 and 4. In this situation person A is over allocated on two days: day 2 and 4. How to get this nicely reported in…
-
Multiple dates for same row added to calendar
On one project, I must complete multiple tasks as part of a single line item. Each task must be completed on a specific date, and I would like each of these dates to show up in my calendar. I only see the option to use a date range or pick a single date column, this wouldn't work for my scenario. I would require the…