Count # of Issues by Date

rlakin52911
rlakin52911 âś­âś­âś­
in Formulas and Functions

I have a issue tracker where issues are submitted daily. Looking for a way to count # of issues by Date (# Opened vs # Closed), using the created and modified system columns. Any help would be greatly appreciated!

· Share on FacebookShare on Twitter

Answers

  • Matt Johnson
    Matt Johnson âś­âś­âś­âś­âś­âś­

    Hi @rlakin52911

    I would insert a helper date column and take the first 8 characters from the created column so you have a date to work with. Then use a COUNTIFS formula in a metric sheet so you autofill future dates for less maintanence on the sheet. Lastly, use the metric sheet data to add widgets to a dashboard to share.

    =LEFT(Created@row, 8)

    I hope that helps.

    Matt Johnson

    Sevan Technology

    Smartsheet Aligned Partner

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!