How can I count how many No" symbols I have in a column depending by a time range

I need to know how many No I have last week.

This is how I try it but the result is always 0 ;(

=SUM(COLLECT({G1}, {G1}, "No", {G1 Date}, >=TODAY(-7)))


Please help.

Thank you

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!