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

Tags:

Answers

  • Genevieve P.
    Genevieve P. Employee Admin

    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!