-
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…
-
Archiving Project in Control Center Should Also Remove Project from Portfolio WorkApps
When you archive a project in control center, it does not remove the project from Portfolio WorkApps. This leads to confusion for project owners and others shared to the project when they still see their archived projects within WorkApps. The only way to remove a project from WorkApps is to delete the project from control…
-
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…
-
Merged: Favorites List Sort/Display Order
This discussion has been merged.
-
INDEX/MATCH formula assistance needed
Hello. I'm using the following formula to match resources with their resource manager (=INDEX({Resource Manager2}, MATCH([Assigned To]@row, {Resource2}, 0), 1) ) and it works great for a 1:1 scenario. However, I have a many to one, or many to many scenario and I need help modifying this formula to accommodate both of them.…
-
How to add an Image into a cell in a Report
We have a single sheet broken into many reports that different users use during a process of development of a product. The sheet holds all the columns and is the single source of truth while the reports give snap shots of each step and only shows columns relevant to that step/user. My question: You can copy/paste an image…
-
Smartsheets for Meeting Notes
I am exploring options for our Project Management team to consolidate applications. One area that I've seen as a gap with Smartsheets is using it for meeting minutes. We currently use OneNote for internal and external facing project notes, status reports, and storing important project emails. I am curious if anyone has…
-
How do I fix corrupt Level Code and WBS Phase
I somehow caused an error in my Smartsheet and now both Level Code and WBS Phase have 'UNPARSEABLE' in every cell. How do I fix this?
