-
Count If with Start and End Date
I need to count the number of projects going on in each quarter. I currently am using this formula: =COUNTIFS({Start Date}, <=DATE(2023, 7, 1), {End Date}, >=DATE(2023, 9, 30), {Helper}, 1) However, I need to include my Start and End dates to get an accurate count. This is my roll-up sheet:
-
Formula Help
Using the below formula to pull serial numbers from multiple cells on one sheet, into one cell on another sheet. =JOIN(COLLECT({Fleet Equipment SN Serial #}, {Fleet Equipment SN Ship Code}, Ship@row, {Fleet Equipment SN Device}, "X-Ray"), ",") What returns is: (12345, 23456, 34567) What I really want is: (12345) (23456)…
-
Sum FUnction Not working properly
I am trying to get the total value for a column and the math is completely off. has anyone encountered this? all i am doing is a simple sum. the total should be 703 not 595
-
Unparseable Error
I have this form I am trying to use on a sheet and it is NOT working, but it works on other sheets making me thing something is wrong with the sheet I am referencing. Help?😔 =COUNTIFS({Area}, "A4 - Urology", {Date}, MONTH(@cell) = $[Month#]@row) Here is what the referencing sheet looks like: There are submissions for A4 on…
-
If and collect
Hello -- in an ideal world, I am trying to pull dates from an existing SmartSheet (all dates live in 1 cell) into another sheet where the main column has the dates listed vertically down and the top row shows each facilitator in a separate column. The intention is to pull their unavailable dates from the existing sheet…
-
Subtracting Days & Months from Specific Dates Using a Separate Day/Date Column.
Hello all, I am having some trouble trying to use the correct formulas to subtract both Days and Months from certain dates. I am also incorporating a helper column that would allow me to change the days or months if needed. Hope this makes sense. I have also attached a screen shot of the table I am working with at the…
-
Is it possible to evaluate multiple predecessors and match to a cell value in another column?
I need to correlate a predecessor row to a work order number in a different column within the same sheet. There can be multiple predecessors. Is there a way to have a formula evaluate multiple predecessors and show a corresponding work order number? Here is a screenshot, I'm trying to figure out if a formula can be used to…
-
Count Referrals by Week when Week Falls Between Two Months
On my source sheet, I have three columns calculated off of a created by date column for day, month, and year. I have the first formula working correctly to count referrals received by week: =COUNTIFS({OBOT Referrals Month}, @cell = 1, {OBOT Referrals Year}, @cell = 2023, {OBOT Referrals Day}, AND(@cell >= 1, @cell <= 7))…
-
Total: Checkbox and Other Criteria
Hi, Need help with a formula that will give me a number based on whether a box has been checked in one column (Survey Complete) + the name of the Prior Business (there are 4 different types) in another column. I'm guessing I will need 4 different formulas to total the number of checked boxes for each prior business name.…
-
Date Range Formula Help
Hey, I am trying to use a formula to find the number of confirmed and requested booking status within a period of time. So for example for finding the number of confirmed booking statuses from today until the end of the list I used the formula below which gave me the correct value: =COUNTIFS({AZA JOURNEY - Itinerary &…