Collecting dates prior to today
Hello I'm fairly new to actually using formulas on Smartsheet but its been a great tool thus far in what I've been doing, I have a question regarding making a weekly rolling number formula, if that makes sense. I want to take one columns information specifying a targeted area in the column and then reference another columns dates, So possibly a countif "Department" which is column 1 - Is less then 7 days prior to today, which would be the created date. Hope I'm making sense lol. This would generate a single metric for that department Weekly
Help Article Resources
Check out the Formula Handbook template!