-
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…
-
Populate a row with the last Friday of each work week for the year
I'm creating a Weekly Hours Tracker for our projects with each week having its own column (W1-W52). I want to populate the date for each week (row 10) as the last Friday of each workweek for the entire year without typing it manually. The columns (W1-W52) are Text/Number, not Date.
-
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…
-
Formulas and functions for tracking delays
Hello! I would love some guidance on if there are any formulas or functions that are useful for tracking delays with a project. More specifically, our organization is hoping to track who was responsible for the initial and subsequent delays with a project. In our sheet, we have columns for: Task, Assigned To (Dropdown),…