Formula Issue


I am trying to reference another sheet column to show how many tours were in 2023. I cannot figure out where I messed up in the formula. Any help would be greatly appreciated! Current formula I am trying: =COUNTIFS({Stanford Hospital Tour Request Range 7})([Tour Date]:[Tour Date], IFERROR(YEAR(@cell), 0) = 2023)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!