-
How to count on another sheet how many terminated employees per month?
Hello, I am trying to use the following formula in another sheet to count how many employees were terminated on the system per month: =COUNTIFS({Status}, @cell = "terminated", Month@row, {Turnover per month 2021 Range 4}, Year@row, {Turnover per month 2021 Range 2}) What am I doing wrong?
-
How to count children rows with multiple criteria
I have tried this many ways and can't figure it out. The column names I am working with are: "CaseRegNum", "Type of Review", and "Status". Each parent row is a different year and beneath each year are cases IDs (these are in the caseregnum column). The cases are categorized into "general" and "special" (this is the type of…
-
Formula Help Countifs and Match
I'm trying to develop a cross sheet formula that will give me an error message if I've over-allocated equipment. This is What I've come up with so far but I get Incorrect argument. =IF(COUNTIFS(MATCH([Equipment Required]@row, {Equipment Total}, 1), >[Equipment Max#]@row, {EDBDate}, >=Start@row, {EDBDate}, <=[Last…
-
If Statement Between Two Numbers
Hello, I am trying to set the status based off %complete. I believe my formula is correct, but am unsure why the status column isn't updating based on the formula. May somebody help me out and please let me know what is possibly missing? Thank you!
-
Average distance travelled in a particular date range by each team
Hi Community, Can you help me with a formula to find the average distance that Team "Blues" travelled in July? Many thanks, Ahmet
-
Count the number of non blank child cells
Hi! The sheet contains the following hierarchy: There are formulas (COUNT(CHILDREN())) in the blue cells of the Missing study column. I need to count the total number of white (child) cells. In this particular case [10] should appear. What the formula should look like? Thank you in advance!
-
Using a Database to Autofill Cells
Hi Smartsheet Community! I am trying to create a cell autofill for email and phone in one sheet using another sheet as a database. The issue I'm running into is how do you select between identical names with different email/phone. In the database sheet, I've created a duplicate checkbox column with a formula that will…
-
Cross-sheet reference limited to under 50,000 references
Excited about the increased cross-sheet reference limit to 100,000, I jumped on the bandwagon and started to replaced the Destination sheet LEFT(SUBSTITUTE(JOIN formulas with the Index/Match formulas using cross-sheet references. In this workflow, we are pulling data from 5 Source sheets into one “Central (destination)…
-
Formula to check a box if it meets multiple criteria in another sheet
Hi! I have two sheets: Sheet A: ID#, Date, and a checkbox Sheet B: ID#, Date Can someone please tell me what should the formula be if I want to Sheet A checkbox to check if Sheet A's ID# and Date match with Sheet B's ID# and Date. I tried a few different formula and it seems like it doesn't work: =IF(AND(MATCH([ID #]@row,…
-
Count how many "On Hold" projects for the Sheet Summary
I have a sheet set up with a (Multi Select) dropdown, and a complete check box, & would like to get a count of how many projects that are NOT complete & are On Hold. COLUMN: Info Still Needed - is a multi select dropdown COLUMN: Complete - is a check box I have tried several formulas with no luck.…