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?
Answers
-
Try this...
=COUNTIFS({Project Findings Range 7}, [Risk Level 30]@row, {Project Findings Range 8}, >=TODAY(-30))
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!