Count if Date Column has any dates older than 7 days

I know that conditional formatting cannot product formulas so this wont work there. I think i have to insert a new column with a formula, but the formula is giving me trouble.

I have a sheet with a 'date submitted' column. I want to highlight any row that is older than 7 days (from the current day) along with two other conditions being met. If i create a formula column to produce "yes" where the days are over 7 days, i can use conditional formatting for the rest.

The formula is what i am having trouble with since the dates and entries are not fixed, there will be more always being added to the sheet.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!