-
Trying to create a formula that determines the current season
I've got a formula that generates the current quarter and one that calculates the current year. Now I'm trying to write an IF statement that creates a value that says S23 by reading if its Q1 or Q2 and then adding the 23 from the current year (2023). This is my current formula, can anyone explain why it's not working or…
-
Indexing across sheets with the same name
Is there a way to Index or search all sheets named Project Metadata? I want to populate a sheet using the project number at the top level.
-
Control Centre - Batch Updating
I am about to launch my first control centre Blueprint and one thing I am wondering is what would be a best practice for recording notes at a program level. We have a status meeting that reviews the projects in the Blueprint Summary.. The client will pass on a tidbit of knowledge in the meeting and we will record a note..…
-
Program Management: Metrics for RAID Logs
Hi all, I am working to mature one of our programs by creating a dashboard that encapsulates several types of metrics, but one set of metrics I'm struggling with is our RAID Logs. I am using a Smartsheet Blueprint to spin up our projects and each project has it's own RAID Log to track against. I'm hoping to hear of how…
-
Project Prioritization Intake Form Examples
Hi everyone, I was curious if anyone has any examples of project prioritization or strategic alignment intake forms? My organization is looking to replace our current project intake process form and replace it with a new form/process that will help prioritize incoming projects. Any insight would be appreciated. Thank you!
-
Transpose cell links from a vertical production schedule to a row/grid sheet
We have hundreds of production schedules for individual projects, each of which share milestone dates that are uniformly named. The milestone dates vary per project and we want to create a sheet that has a row for each product and columns for the milestone dates. This will enable project tracking on a global level. The…
-
Count children but only some of them
How should this formula look if I want to only count children that are 'Open'? ="Project stage name - " + COUNT(CHILDREN()) I am using on the parent row in a project risk register so I can collapse stages not reached to focus on the risks for the current stage. However, some of the risks in the current stage are now…
-
SUMIFS with 9 criteria
I am trying to sum specific values based on a dropdown list in one column and display that sum in another column. I have an "Amount" column , a "Total Final OEP 0708 Cost Center Spent" column , and a "Cost Center" dropdown column. I want to sum CHILD rows in column "Amount" based on the drop down option that is selected.…
-
Free Float [Slack] Formula
Calculate the float (or slack) between the task and the next successor task. If there are multiple successors, then it will select the one with the closest start date. Free Float (FF): The amount of time that a schedule activity can be delayed without delaying the early start date of any immediately following schedule…
-
New in Smartsheet: Critical Path and Duration in Minutes, Hours, and Weeks
We are excited to announce that Smartsheet’s two most requested features, critical path and duration in minutes, hours, and weeks, are here! For every project, having a greater level of control over task duration and working hours helps increase efficiency and accuracy in planning. Now, anyone managing a project has the…
