Having trouble with pulling data with Countifs


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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!