-
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?
-
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
-
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…
-
Is it possible for multiple column links, formulas, and manual data to all exist in one destination column?
Can a single destination column support multiple column links coming from different source sheets to populate different rows within the column, as well as allow formulas or manual data entry in other rows in that same column? I have different sheets (A, B, C) where teams document their capacity month to month. Each month…
-
Lagging Formula Calculation
Hi all, Question: What makes cell formula update/populate a value and why would there be a long delay? Here's my issue: I noticed a request was stuck in my workflow, and when I reviewed the cell history on the helper columns I noticed the culprit was a cell with a relatively simple formula that didn't populate a result…