-
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]…
-
Calculating costs for tasks with multiple assigned reources
Hi, I am using the following formula to calculate the effort costs for a task. It references a list of resources with allocated rates. For a task with one resource assigned, this work fine. =[Effort (hrs)]@row * INDEX({Rates}, MATCH([Assigned To]@row, {Names}, 0), 6) However its not good for tasks with multiple resources…
-
COUNTIFS WITH DISTINCT
HI Everyone, I am trying to calculate the distinct values in column Contain using countifs and distinct however i need the range of contain to be included in the range. Column7,8 week3 will be my source chart. COUNT(DISTINCT(COUNTIFS()))) i've tried using this but i can't incorporate the "contain" column, would you…
