Count of how many rows have been added between monday-sunday, resetting each week

Alex Purcell

Hi,

I'm hoping to get a workflow to send a notification to a Slack Channel once a week with the count of how many issues have been uploaded that week. This would count from the closest Monday until resetting again the following week.

Is anything like this possible?

Cheers team

Mark Cronk

Hi @Alex Purcell ,

To count rows added during the current week the formula would be:

=COUNTIF(Created:Created, WEEKNUMBER(@Cell)=Weeknumber(Today())

You'll need the system column Created which is the date-time the row was added.

I'm not familiar with Slack but the automation should be pretty straightforward.

Help?

Mark

Alex Purcell

Sorry, by "issues" i mean new rows added

Mark Cronk

Hi @Alex Purcell ,

To count rows added during the current week the formula would be:

=COUNTIF(Created:Created, WEEKNUMBER(@Cell)=Weeknumber(Today())

You'll need the system column Created which is the date-time the row was added.

I'm not familiar with Slack but the automation should be pretty straightforward.

Help?

Mark