-
Project Schedule Baseline - Is History Kept when Re-baselined?
We are using the Project Schedule Baseline functionality, but recently learned that the Schedule can be Reset or Removed. Is there anyway to track how many times a Schedule has been 'Reset' or 'Removed' and baselined again? Our concern is that without the history being tracked on how many times it's been reset, we won't…
-
Formulas Question - Referencing Another Sheet
Good morning, I am trying to pull calculate an average from data being pulled from another sheet. I want to be able to calculate the average duration, by month of completed projects. I basically want to say what is the average of the duration fields if the phase is completed and the end date column is in the month of…
-
Report pulls in a primary column without me specifying it
I have a smartsheet, it has a helper column titled Full Name, which is calculated using task name and parent names. In the report section, I select the sheet, and the specific column and criteria. but then the end results shows me a column for task name which I don't want to see. I am not sure why it is showing it to me,…
-
Counting number of times a deadline is missed
I need a formula for a sheet summary that I just cant wrap my head around, might even be two formulas working together...Maybe I am over thinking it. I need a formula to look at a "date1" column and a "date2" column on a sheet and then I need it to count the number of times the difference between those two dates is more…
-
Automated Directional Arrow Symbols
I am trying to compared two columns in my sheet, based on if the numbers in the column grew, shrunk, or were unchanged. I'd like to automatically show this with the up/down/unchanged symbol. Is this possible? I was able to get the up/down arrows to automatically show, but I'm not sure how to incorporate the "unchanged"…
-
Summarize Report Function with Dropdown Menu Selections
Hello, I am looking to determine the instances of a particular dropdown value entered into my sheet by using the report function with the summarize feature in order to determine, based on the weighted value, how large a portion of total any one category may hold. Easily thought about as a pie chart. My dropdown values…
-
Conditional Formatting
Hi I have a sheet where the user would like to have rows highlighted in Red, Amber, Green based on when the last review date was completed: Review in the last 10 months - Green Review in last 11 months - Amber Review in last 12 months (or more) - Red I'm unsure the best way of doing this - do I need a formula in a helper…
-
Filtering in Reports help needed. Days past and future
Hi, I want to filter a report to show in the next 30 days and in the last 5 days. I have it set Expire Dates is in the next days 30 and Expire dates is in the last 5 days, but it's only showing the past 5 days. I have it set as and so should work. Can someone advise me? Thank you
-
Sheet Summary Report with Dropdown
I'm creating a sheet summary report to use for a dashboard and have my source data broken out by phases. I'd like to be able to group the report data by phase, so I tried adding a single selection dropdown to the sheet summary. However, it's returning blank in the report. The source data is a project management / Gantt…
-
Dashboard- weekly project status submissions
Hi, I would like to create a monthly dashboard that displays which project managers have submitted their status each week. I have a master Project Management Sheet where project managers submit their status. I plan to have an automation that clears whatever the project manager has added , in order to make room for their…