How to create a conditional formula with date specifications?


How do I create a formula that counts the number of rows containing [STATUS] “Green” and have [DATE] = Today and [DATE] = Last Seven Days from Today. I do not want to capture rows that are older than seven days from today.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!