-
How can I make a multi-IF cross-sheet INDEX formula?
Hi there! I've been stumped on trying to make the correct formula for my situation. Any help is greatly appreciated! In one sheet (Data Collection sheet) I have a column for Sample ID and a column for Results. In another sheet that I'm using to report out, I have a column for the results of each possible sample ID. I want…
-
Status update from daughter rows
Hi Smartsheets Team, I have a column "Status" that has mother and daughter rows. I am wanting the mother "Status" to update when the daughter rows change. So for example APQP would be "Not Started" until Pre APQP or MFG Plan Review is marked as "In Progress" then APQP becomes "In Progress". When BOTH are marked complete…
-
COUNTIF Issue on Sheet Summary
I am trying to see how many times Q1, Q2, Q3, and Q4 appear in my "Quarter" column on my sheet within my sheet summary. I am using the formula =COUNTIF([Quarter:Quarter], "Q1") to try to get just Q1 and it is not working. Any suggestions on why that is not working?
-
Count If Site matches Question
Hello, I am trying to pull a count of a column "Food Safety Hold" if the "site" matches. I am trying this but it is not working. =COUNTIF(MATCH({Site}, Site@row, {Food Safety Hold}, 0)) =COUNTIF({Food Safety Hold}, Site@row, {Site})
-
Count if date is in the past
Hi All, I am looking for a solution to a problem, I am trying to pull together a chart for a dashboard, displaying the number of overdue documents under review we have - the sheet is set up as below, and I have set up a 'metric sheet' however I am not sure this is the best solution. I have been using this =COUNTIFS({Master…
-
IFERROR INDEX COLLECT if greater than 0 issue
I am trying to collect from a separate sheet the counts of holds if the site matches and if the count of holds is greater than 0. I am trying to collect the Count of holds if the site matches if the count of holds is greater than 0. Can someone please help me try to collect this. I tried below and did not work:…
-
Duplicate Data combined for distinction
I was reading this help and it has some parts I need and noticed it referenced a sheet that no longer exists. https://community.smartsheet.com/discussion/69259/formula-to-pull-data-from-one-column-and-combine-duplicates What I am looking for to get going and just hit a dead end after reading in here for the last few hours.…
-
Formula changes without showing in Activity Log?
I have this formula: =IF(ISBLANK(Location@row), "", INDEX({Location_code_helper Range 1}, MATCH(Location@row, {Location_code_helper Range 2}, 0)) + "-" + RIGHT(Year@row, 2) + "-" + COUNTIFS(Location$1:Location@row, Location@row, Year$1:Year@row, Year@row)) It basically creates a custom identifier that uses the year and a…
-
How to COUNT multi-select drop down list.
My sheet is for process improvement ideas. When one is finished, we have a column where we can check off which areas we improved (some are just Cost Savings, some have 3 or 4 options selected). I'm trying to count how many times each improvement category is checked off on the entire sheet. Note: I have 5 categories, for…
-
Count cells with specific values in row with matching ID across sheets
Hi, I have the following requirement: I have 2 sheets, each with the [Project Number] column as the ID. Let´s call the sheets [Intake Sheet] and [Picking List] The [Intake Sheet] holds, for example, a range of 10 columns in which machine part names are entered. Let´s call the columns [Machine part 1] … [Machine part 10]…
