-
COUNTIF cells match in different sheets
I am struggling to get a count if cells match when referencing different sheets. I am working on "Sheet 0" and want to check how many cells in "Sheet 1" match cells in "Sheet 2" for one column. Here is my formula: =COUNTIFS({Sheet 1 column}, ="{Sheet 2 column}") have also tried without parenthesis. I currently get a 0…
-
#incorrect argument for COUNTIFS and ISDATE/checking DATA exists
I am trying to use a COUNTIFS statement that looks at a Sheet and counts rows that contain a Column with specific text (Names, first and last) and a column that is a Date. I'm writing this formula in its own sheet. The sheet contains a list of 70 names and my formula will use that cell to reference that in the first IF…
-
Sort based on last name
I know this is a SIMPLE question, but I couldn't figure out how to do that. I have a column that consists of contacts, but I want to sort it based on the last name, not their first name. How would I do that?
-
Count Ifs Specific Year
I am trying to Count Ifs the word "Bidding" appears in a column based on the Bid date being in 2024. =COUNTIFS({Electrical Status}, CONTAINS([Primary Column]@row, @cell), {Bid Date}, YEAR(@cell) = 2024) this is what i have (primary column is referencing the word bidding). I am pretty sure it has something to do with the…
-
Sumifs or countifs and what is the formula
I have 3 columns of data: Column 1 is a location (for example 101, 102, 201, 202) Column 2 is a date (for example 12/1/2023, 12/2/2023) Column 3 is a duplicate transaction labeled as D or if not a duplicate it is blank Based on the location of 101, I want to see how many transactions occurred on 12/1/2023, and are not a…
-
Count if - Text
Hi, Can you please help me to figure out why this formula is returing 0 while the range contains this text? =COUNTIF([Data]:[Data], "*Risk01*") The range is a drop down column allowing selection of multiple risk. I'm looking to obtain a number how many times each risk was selected. Risk01 is not the full text, only part of…
-
Depreciation Cost Help
Wanted to use the template listed to create a new sheet and see if it would work that way, but it isn't available any longer.. Essentially, I'd like to be able to find the depreciation cost year over year of assets currently being tracked in a sheet. We display the cost price paid on purchase, and the date of purchase, but…
-
Not sure why I cant get this to work? TIA for any guidance!
Need assist on another formula: =IF(CONTAINS(Tier@row, 3), "ME", IF([Independent Reviewer]@row = "ME"), "AH", IF(CONTAINS(Tier@row, 4), "SM", IF([28. Assurance Project PIC]@row = "SM"), "JL")) I am getting an error: "#CIRCULAR REFERENCE". Again, any help is greatly appreciated!
-
How to pull data for a column from another sheet based on criteria from two columns?
I currently have two Smartsheets. One Smartsheet is a contact list based on location and department. The other sheet needs to be able to pull a contact from the contact list based on the location and department selected. The formula I tried that is not working is below. =INDEX(COLLECT({CI Board Contact List Facilitator},…
-
Sumifs formula circular reference error
So the first 36 rows on the sheet are a summary of the data below. I want to capture the sum of values that meet a specific criteria. =Sumifs([Value]:[Value],[Type]:[Type],="Type 1", [Category]:[Catergory],="Cat A" but it's either blocked or the circular ref is poping up. It's also putting the "Blocked" in other cells" - I…