-
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})
-
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:…
-
Status update from children rows
Hi Smartsheets Team, I have a column "Task" that has parent and children rows. I am wanting the parent row "Status" to update when the children row "Status" changes. For example, Parent row (Real Estate) would be "Not Started" until one of the Children Rows (Pro Forma, LOI, PSA, etc) are marked as "Processing", "Pending",…
-
Using INDEX but returning blank if match found
Hello, I am using the following formula to reference another sheet: =INDEX({DISASTER CLOSINGS Range 1}, MATCH([Store Id]@row, {DISASTER CLOSINGS Range 1}, 0)) This returns #NO MATCH for cells that, well frankly do not have a match, and the corresponding number if it does have a match. That works as intended. But... I want…
-
if formula .
I have three columns, I want to get the count if the week is 8, the year is 2023 and the country is US. if that condition is not met I want it to return nothing and have the cell empty. Can anyone help =COUNTIFS({Submit FY}, "2023", {week}, [Primary Column]@row, {Country}, "US")) The formula initially looked like that but…
-
Is it possible to separate an address into Street, City, and State?
I have a column of addresses that I want to separate into 3 columns for street, city, and state. For example: 1 Tesla Road, Austin, Texas, 78725 Street: 1 Tesla Road City: Austin State: Texas Is there a formula I could use to separate the address into 3 columns by the commas?
-
Issue with CountIfs and multiple OR() statements, and criteria
I am hoping to get some help with a formula. I need to count based on multiple columns in a sheet, and only certain values in each of those columns. in the below example counting number of Demand for RN (staff type), and for only early start times, for Today(). This is what I have so far, I am thinking the multiple OR()…
-
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…
-
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…
-
Adding an AND into a formula
Good morning, Community! Current formula (which is working): =IF(CONTAINS("APP", [Employment Type]@row), JOIN([Dropdown Selection]@row:[Employee Status]@row, "; ")) However, I need to include if the Employee Status equals Active within the above and not sure on the syntax?