Having trouble with pulling data with Countifs

Options

I am trying to get a table to count the amount of risks over the last 30 days with either critical, high, medium, and low. I am trying the following:


=COUNTIFS({Project Findings Range 7}, [Risk Level 30]@row), {Project Findings Range 8}, ">=TODAY(-30)"}


Does anyone have any good tips?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!