Counting number of new rows using Created (Date) and resetting each week


Has anyone posted a formula to use that counts the number of new rows added to a sheet based on the system generated create date? I want to do this and have it reset the count each week, perferrably each Monday.

I want to: "Look in the Created (Date) column of Sheet 1 and count if the date [that this row was added] is within this current week, and give me the count on Sheet 2" This logic to me would automatically reset depending on when "this week" is. I've tried all combinations of using the Countif function, the DateOnly function, and the Weeknumber function. None of these seem to "click" to me.

I want to eventually use this count as a metric on a dashboard.

Any ideas?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!