-
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…
-
Need help with formula to pull list of chapters that are past due
Hello, We use very large SS and I'm trying to fully automate our status reports. In our Schedules for each chapter we have 3 rows of data, planned/revised/actual. I am wondering if it's possible to write an equation for each column that would do the following: Look at the same chapter number rows If the planned date in the…
-
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.
-
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…