-
Sub-Projects within a Larger Project within a Portfolio
We have various distinct teams (Business Development, Engineering, Production/manufacturing, field installation), and we think it best we develop and maintain our projects separately. However, we still have the need they roll up into a parent project, which may in turn roll up into a portfolio. I believe this can be done,…
-
Dashboard Chart Widget Vertical Axis Numbering
So, I have added a few new charts to an old dashboard, and for some reason the new charts are adding a decimal and two zeros to my vertical axis numbers. It isn't the end of the world if the numbers look like this: 5.00, 10.00, etc. But, I would prefer that they simply be whole numbers. In previous charts I have created…
-
Combining IF/AND/OR to return a value when multiple criteria are met
Hi Everyone, I am trying to filter out tasks on my Gantt chart occurring over the next three weeks. We found a good combination of filters that works for reports, however I want to be able to create a filter like this for the sheet so that the tasks can easily be edited in real time. Sheets do not allow for the hierarchies…
-
Hyperlink the numbers in the dependency column (Predecessors)
It would be great to have the numbers displayed in the dependency column (predecessors) as hyperlinks to the rows.
-
Merged: Support for Date Time format
This discussion has been merged.
-
Project management template packet- Forms Included
Hello, I have generated a 'Project Management Template Packet' to be re-used by Project Managers each time they begin a new construction project. One important item we use is an RFI Form- used by field personnel to generate 'requests for information', which populate a Smartsheet used internally. This information is then…
-
Email Alerts for Multiple Rows, Individually
Is there a way or setting where I can control how email alerts are sent when multiple rows match the criteria? For a while, even if multiple rows matched the criteria, we would always get individual emails/alerts for each row. (i.e. 6 row match criteria = 6 emails). However, after the recent update, I now only get 1 email…
-
New to Smartsheet - Project Management
My company uses Smartsheet, all jobs for the entire division are loaded into one sheet (tasks, deadlines, completion dates, etc). I am new to the company, and have never used Smartsheet before I am responsible for about 1/3 of the projects in that sheet. All I want is to be able to pluck from that "master sheet" the…
-
Extract Cell History For Formulas
Hello, Is there any way to extract the Cell history to calculate formulas. What I am trying to do is create metrics off the dates in the cell history. I.E. if a Dropdown list column starts on July 1 with Value 1 and changes to Value 2 on December 10th then Value 3 on December 21st. I want to measure and tract the time…
-
Use cell history to calculate task delay
Hi, I am new to Smartsheet hand have been trying to find an answer to this without success. If I look at examples to track delays for tasks I always see folks adding extra columns like the actual start and end date to calculate the delay. I guess it works but I was wondering why that's required as you have the original…