-
Predecessor question
I need the Date of Sample Shipment to start within 20 days of the Date of Manufacturing Start Date. However, the predecessor I have there isn't working properly. What should it be? Thank you so much
-
Modified SUCCESSORS() function to report more than just direct successors
WHY IS THIS USEFUL? This updated function would allow us to filter the spreadsheet for only the driving path to a particular row#. This would be similar to a filter for critical path, but enable much more flexibility. Current status: I've successfully generated a "Successors" column, listing direct successors of each row,…
-
Formula to Flag Tasks that are on the Critical and / or Driving Path
I'm aware how to highlight these in the Gantt, but if I wanted a checkbox to flag which tasks are on the CP and which ones are on the DP, anyone have an idea how to do that?
-
Column formula resulting in #circular reference
Does anyone know how to revert a sheet to a prior version after a column formula resulted in replacing all of the values with #circular reference? Would all entries have to be manually re-entered?
-
Copy the VALUE ($) from a Formula (Cell) into another Cell
I know you can use a formula like this: =[Projected Payment Milestones (+)]@row to copy the "value" from one cell to another (because that cell is a formula); however, I need just the "value" formatted as a number ($) to be copied; because in my REPORT I am not able to edit the data as it is recognized as a FORMULA (fx) Is…
-
Grouping Automation - is there a way to checkmark a group of users based on one singular check?
I currently have a sheet in the following format: Primary Owner Secondary Owner Group Title Username Access Status Primary & Secondary Owner - contains names of owner Group Title - group name of which users belong to Username - user names Access - checkbox column (default value is 'unchecked') Status - dropdown list (Open,…
-
Troubleshooting Index/Collect Issue
I have one sheet that houses all updates and comments for specific Releases (Sheet 1). I have a second sheet that lists every Release being worked on (Sheet 2). I am trying to pull only the most recent update from the Sheet 1 into Sheet 2. I am able to pull over an update when only using one criterion (either the Release…
-
Convert Value To Static
I need help, please! I created a process that allows employees to request deactivation periods from their snow assignment. The ogranization allows for 5 employees for days and 5 employees from nights to deactivate at one time, per day. I am using the following formula to retrieve the number of slots available:…
-
Pulling column from one Smartsheet to another, automatically updates
Currently, there is a form linked to a Smartsheet that automatically updates every time the form is submitted. I need to graph data from specific columns, which I want to be in another sheet for visual clarity. From what I understand, I need to pull that data into the sheet I am charting in before I can plot it. What…
-
Formula Help Needed
Hi all, I have a sheet "Transition Tracker" where my team adds data that can often change throughout the lifecycle of a project. When this data is initially added, I have an automation that copies it to another sheet used by another department. I need to add a formula to the other department's sheet that will update a…