-
Creating Formula to COUNTIFS two referenced columns from another sheet.
I'm attempting to create a formula that COUNTIFS two columns from a referenced sheet and am having no luck. Here are the two I've tried: =COUNTIFS({Start Date}, 0, AND({Not Applicable}, 0)) Error - #Incorrect Argument Set =COUNTIFS({Start Date}, 0, AND({Not Applicable}, 0)) Ends in a total of 0 The 0 isn't a true result.…
-
Adding # of days with in a date range
this is what i came up with looking at other people i keep getting #invalid operation =SUMIFS({2021 Sioux City Utility OSHA 300 Form Range 18}, {2021 Sioux City Utility OSHA 300 Form Range 1} <= DATE(2021, 1, 31), {2021 Sioux City Utility OSHA 300 Form Range 1}, >=DATE(2021, 1, 1)) the first range (range 18) is the #number…
-
Multiple criteria with INDEX and MATCH / COLLECT with MAX Functions
Hi, I have the below columns in my Smartsheet and I would like to retrieve Finance column value if Quarter=2, Year=2021, Req Type=L and Max(Row ID). I tried with below query but failed and I am not able to see how MATCH / COLLECT Function can be used. Any help would be greatly appreciated. Thanks in advance, ~Chitta
-
Average for multiple criteria + rows
I need to get an average of a rate for multiple row getting it by country
-
splitting sheet into two - need help
Hi, I reached max capacity with a sheet and now need to split it into two - however, we were copying data from our "advertisements" into the application rows - now all applications will be on a separate sheet, however, I still need to include information from each ad into each applicant's row - for example, each ad has a…
-
Using Countifs with dates, how to fill down the formula but with the next upcoming date
Hi, I was successfully able to use the countifs formula to cross reference another sheet to count the amount of times on a specific date a certain response came up. =COUNTIFS({Case Log Range 1}, =DATE(2021, 8, 1), {Case Log Range 2}, "Positive") What I would like to do next if figure out how to fill down the date in the…
-
I am trying to create a COUNTIF formula that counts the number of rows where the date is 100 >
TODAY-date. It doesn't seem to count all the rows where the date has more than 100 days. This is the current formula I have right now =COUNTIFS({role}, "abbie", {PRJT}, $[Project Type]@row, {date}, @cell > (TODAY(100)))
-
Formula to only show characters before a specific character in a cell?
Hey friends, Needing some help creating a helper column. In column from imported report I get, "Asphalt Distributor (45)" where the "45" represents the quantity of assets in that category. I need to create a helper column that extracts the "(45)" and shows only the "Asphalt Distributor". Please note: there are many asset…
-
If AND Countifs formula help
Hi - Trying to have a boxed checked if info from 2 fields on a row on sheet A are found on sheet B in the same row. =IF(AND(COUNTIFS({UCA Vendor}, [Vendor]@row, {UCA E#}, [E #]@row, >0, 1, 0))) So IF data in "UCA Vendor" on sheet B matches "vendor" on sheet A....AND "UCA E#" on sheet B matches "E#" on sheet A - check the…
-
Nested MAX formula
Is there a way to use the MAX formula to look at a created column and check a box for the last entry of each day? I'm having no trouble getting the MAX to work for the full sheet, but it's not working for each day. I'm looking at the created date column and trying to return a checkbox from another column that is checked. I…