-
Why won't durations parent rows in lower levels of multi-tiered hierarchy on project schedule roll u
I have a project schedule with multiple levels of parent rows. In the Duration column, the 2nd and 3rd tiers of parent rows do not subtotal the children underneath them. Is there some other setting or consideration for getting this to roll up properly? Will Smartsheet allow a 2nd or 3rd tier parent row to subtotal the…
-
New User Help - formulas and ranges
Hi, I'll try to describe in detail what I want to do and would appreciate any help you can provide. I have a range of cells that show Red,Yellow or Green Balls and this is used to check the status of each stage in a project. I would like to also have a cell at the top level of the project that displays RED if there are any…
-
Update email address for contacts does not update shared sheets automatically
Hello all, I have been in the process to update email address for some of my contacts due to the change of domains. However in doing this I realized that all my sheets shared with those specific contacts are not updated with the new information. Let's say that I have already shared or assigned tasks to these contacts. I…
-
count "on time" dates
hi there, I am trying to count all dates that are on time comparing my due date column and delivery date column... tried countifs, but it wont let me compare the whole columns... please help. Thanks nino
-
Identifying Department Reasources in a Project Portfolio
Hi, I am relatively new to Smartsheet. I have built a portfolio of projects for our company. I want to identify what departments are involved in each of the projects in the portfolio. This is just a very high-level listing of departments. While we are not trying to include the amount of work estimated for each department…
-
Formula Help
Hello, Looking for a little quick assistance. Not sure why I can figure this out, but I guess I'm just not as intuitive with the SmartSheet logic. I have a metrics sheet that I am using to provide data from other sheets to populate a dashboard. I currently have this formula and similar formulas that pull data within a…
-
Counting RYG Balls
Hi guys, Is it possible to count the number of balls according to their respective colors? Many thanks in Advance.
-
Current Month automatic
I am looking for an automatic way to generate reports that compare last month and current month. I have 6 account sheets that show totals by month and category. I would like to pull all 6 accounts into one sheet that shows last and current month totals by category. Can anyone provide guidance here? TIA.
-
Creating a new Report based on a single Sheet
I create Reports frequently and am comfortable with the process. What I'm wondering is if there is an easy way to create a Report from within a Sheet that is based on that same Sheet? I guess I'm looking for an option in the File menu that says Create a Report from this Sheet vs. starting a new Report and then selecting…
-
Is there a way to collapse the rows in a Gantt chart?
I'm trying to take a spreadsheet and present it in a way that has one row for each category of item, and then multiple cells across that row to represent the emails sent in that category. This is a calendar of sorts. Each category would be associated with a color. (That's the part I have figured out.) I saw Smartsheet's…
