Countifs Past 90ds referencing another sheet

Options

Hi,

I am trying to make a dashboard that shows the top 10 pieces of equipment with the highest number of issues in the past 90d.

I have my primary sheet that collects the data (Primary), and a reference sheet I am using to collect a count. I am just struggling to have it filter the last 90d. Showing #invalidoperation

=COUNTIFS({Emergency Work Order_Anniston Range 1}, CONTAINS(Equipment@row, @cell), AND({Emergency Work Order_Anniston Range 4} >= TODAY(-90)))

I tried to initially use the report to filter it down, but it shows all equipment issues, and unable to show only the top 10 on the dashboard.

Thanks in advance for any help!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!