-
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…
-
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…
-
Best Way to Create a Stacked Bar Chart from multiple columns
I have a sheet that I pull into a report. The report I then want to use to make a stacked bar chart and put into a dashboard if I can. The columns I am trying to make into a stacked chart are: Lead, project and phase. The issue is that there are several leads and I need the stacked bar chart to show in different colors for…
-
Add a UNIQUE() Formula Function Similar to Excel
It would be valuable to introduce a native UNIQUE() function to Smartsheet, similar to the functionality available in Excel. Use case: data governance, QA, and business intelligence As a data administrator, I frequently need to generate a distinct list of values from a column in order to validate data quality, identify…
-
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…
-
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.
-
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…