How can I use countifs to sort Modified date?


I am trying to create a dashboard to help me sort through our companies updates in emergencies, which they will submit through a form. Each section has a symbol of red, yellow, green, gray. I have the formula to summarize them by section. I am looking to pull how many reds based on time now. Since some incidents may occur & last more than 24 hours and Exec will want daily reports to summarize I am trying to create a formula to only pull the symbols within the last 24hours.

I am very new to this but this is what I have right now for a formula

=COUNTIFS({Activation Updates Range 1}, "red":{Activation Updates Range 11}, AND>=TODAY(-1))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!