I want to set a formula that only picks up the last 7 days

Can somebody please help me with a formula to pick up some conditional data?

e.g. =COUNTIF(Column 1:Column 1, "SOLD") .....and then I want to add a condition showing entries in the last 7 days (including current day)

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!