-
Trying to sum columns based on value chosen from linked sheet
Scenario: I have 2 sheets: "AFE" and "Lines". There is a 1-to-many relationship between AFE and Lines (one AFE may have many lines), but I haven't set up parent-child in "Lines" because users will add entries in any order and I can't enforce any kind of sorting or parent-child relationship. In "Lines", there is a linked…
-
derive parent name into another column
I am trying to capture HRB in the red highlighted cell can you anyone advise on the formual please i am using the following but getting a blank =IF(COUNT(ANCESTORS([HRB LRB]38)) = 3, INDEX(ANCESTORS([HRB LRB]38), 2)) @Paul Newcome can you please assist me with this if you can?
-
Managing multiple due dates
Hello all, I need help creating a formula to select the most recent due date for a row. We currently have an automation that removes rows when the due date is past. Some rows have multiple due dates. We would like to enter all dates in one row, and have the sheet utilize the most current date to sort the row and then…
-
avoid pulling duplicate value
the above is a tracker i want to pull some value into the tracker i want to pull values from are show below: there are duplicate job numbers in the first screenshot but i only want to pull the value against one of them not all of them to avoid duplicate sums can anyone assist please? @Paul Newcome hi Paul, are you able to…
-
Date column auto update when changes are made
Hi, I have a sheet that lists a bunch of different sheets and workspace. On that line I have a date column when it was last updated. I was wondering, can I get that date column to auto update when a different sheet has changes made to it? Or somehow create a dashboard or report that mimics this.
-
Split Multiple Selections In Single Form Into Individual Rows (Core Product)
There have been a number of people asking how to make multiple selections in a single form and then have those selections broken down into individual rows, and the previous answer was always to use a 3rd party app, a premium add-on, or the API. Below is a set of detailed instructions on how to accomplish this within the…
-
Simple nested IF Statement not working
I need to set a value of a cell based on the value of another cell in the same row, however I keep getting "Incorrect Argument Set" or no value at all. Column A is a department Column B is manager name, based on department chosen. I want to achieve the following: If Column A = Department 1 then Column B = Manager 1, else…
-
List of Locations
I have a master sheet with students and the locations in which they live. Some students live in the same location. I need to make a sheet that shows the unduplicated list of locations where students live. I need this on a sheet so that I can then add more details about each location. The vision is that I'll have a list of…
-
Formula help required
Hey Team, So here's the situation, I need to report on a dataset, grouped by client name, then by job number: I'm importing a dataset into Smartsheet; filenames should be in the below format: Great. I can run a formula to break this up and run the report. Right? The issue Human error. Some examples of incorrectly named…
-
Formula to Flag Duplicate Values
Hi - I have been trying to create a column formula that will flag duplicate values in my [SKU] column while leaving the first occurrence unflagged. Some of the values in the [SKU] column are either Blank or "TBD" so I would like to ignore those values. My ultimate goal is to be able to filter my report from this source…