Metric Sheet for dashboard

Kirstie Winn

Hi,

I am working on a dashboard with a Metric sheet. I have the formula to count my tasks =COUNTIFS({Emerald Workflow - Status}, @cell = "completed"). What I would like to do is add in only if date submitted or completed in the last 7 days. the Date Submitted is a system date.

Is this something we can do?

Kirstie

Genevieve P.

Hi @Kirstie Winn

No problem! You'll just need to add in a second Range and Criteria.

The next range would be your Date Submitted created date System column. Then the criteria would use the TODAY function to find anything that was created after 7 days ago, or -7 days.

{Created Date Range}, >=TODAY(-7)

So in your formula:

=COUNTIFS({Emerald Workflow - Status}, @cell = "completed", {Created Date Range}, >=TODAY(-7))

Keep in mind that the TODAY function will only be able to tell what day Today's date is through a few actions, see this article, here.

Let me know if this works for you!

Cheers,

Genevieve