Formula question

I would like a sheet summary column to count if a check box has been checked and then by todays's date minus 7 days.

=COUNTIF([Show Stop]:[Show Stop], 1 < TODAY(-7))

I think Im close but it calculates zero.

Any ideas on the formula?

Thanks!!!! - JP


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!