How do I pull a count from a column by two other factors from one smartsheet to another sheet?


I'm trying to pull the number of publications that have been published by year, where the data live in three different columns. I want to pull that data to a different sheet. The formula I'm using is this: =COUNTIFS({R&D Presentations and Publications Range 1}, @cell = "Publication", {R&D Presentations and Publications Range 2}, @cell = "Published", {R&D Presentations and Publications Range 3}, IFERROR(YEAR(@cell), 0) = 2021). This at least has gotten me closer to a count, which shows as 0, and is incorrect - it should be 5.

I've gone back and forth with smartsheet team members without success. Does anyone know how to fix this?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!