Capture metric each day and add to new row

I have a number of Harvey ball metrics (count of red, yellow, green tasks) and things that change every day. I haven't really seen any way to capture and store these each day at a particular time (or hourly, weekly, monthly). Anyone have a good solution for it?

Example of metrics I'm collecting on-the-fly from Control Center summary sheets... would love to be able to graph the health over time.. day by day.

Find more posts tagged with

Reports

Integrations

functionality

Project Management

Accepted answers

L_123

The only way currently to convert a cell with a formula to a static cell is the copy/move workflows. You can set up a sheet to receive these, create a column that forces a change every day in the rows you want transferred even if there isn't a change in the data (example would be a =today() formula dragged down) and use that as criteria for the workflow.

Then base your charts off the historical data sheet.

All comments

L_123

Then base your charts off the historical data sheet.

Ezra

I had completely forgotten about that workflow! Thanks!

Built the sheet that captures the data each day, made a couple reports to look at different ranges of time... and added some sample data to make sure it displays what I need.. perfect :)

Screen Shot 2020-05-14 at 12.00.28 PM.png

L_123

NP Glad it worked for you.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.