Metric Sheet for dashboard
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
Answers
-
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 458 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!