Count Number of Records in current year

Options
M. David
M. David ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

Hello. I am trying to use a COUNTIFS formula to count the number of records in a second sheet that meet two criteria; the Project Status of the record matches the project status of the row where the formula is, and the year of the Move-In Date of the record is the same as the current year. I have the formula in the pic below. I hobbled this together based off of several old community discussions. If I remember correctly, it was working, but has now ceased working correctly. 

  • Master Sheet Project Status is where the project status is I am trying to match with the one on the left. 
  • Master Sheet_Move-In Date is the column I want to be evaluated for the matching year. 

The "YEAR(@cell)" to the end is what I am not sure of and the place where I believe the error is. Thanks for looking at this. All help is appreciated.

Operational Count Pic.JPG

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!