-
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…
-
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…
-
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?
-
Expiry for Update/Approval Requests - Automation
The ability to have update/approval requests expire and become inaccessible after a certain date. An expiry date will also allow for the automation of reminder of request. There are times when an update/approval is needed to reach a deadline. The sheet user must manually delete the request on the row to avoid changes. If…