Using a COUNTIFS formula if date criteria is met
Hello smartsheet community,
I am having some serious difficulty getting a COUNTIFS formula to work based on if a row in another sheet meets a data criteria.
My COUNTIFS formula works right now when referencing another sheet, but I would like to use the same formula and add onto it another function which will make it more accurate.
What I'd like to have is a formula which looks at another sheet and first looks at the DATE column which all have dates entered - the formula looks only at the rows with a date in the date column that is between X and Y dates - Then of those rows which have a date in the date column between X and Y dates - a COUNTIFS formula is performed on only those rows (I already have the COUNTIFS formula).
Please help! I have been going at it this whole week to no avail!