Hi, I have a dashboard that keeps on updating, how do I see last weeks data (In order to compare)? Is there a way to view metrics every week, to auto-update from a week before? Thank you!

Ah. Ok. So in the new sheet you will want to be sure to have a system generated column that captures the created date for when the new rows are copied over. In the top row of this sheet, you would use this formula to pull the most recent row's data to the top: =INDEX([Column Name]:[Column Name], MATCH(MAX([Created Date]:[Created Date]), [Created Date]:[Created Date], 0)) Put this in the first row of every column that you want to display the data for, and then reference this top row in your dashboard.

Metrics

Answers

Paul Newcome ✭✭✭✭✭✭

12/28/20

It very well could be. It depends on what is in the created date column for those rows. If one of those rows contains the MAX, then the formula is working as it is designed to. The problem would be that there is "blank data" to pull.

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Trending in Formulas and Functions

Check a Box if Between Dates on Another Sheet
Hey all, I am trying to build a formula to check off a box on my sheet if at least one date is found between two dates on a separate sheet. I've tried a million variations but here's what I have so far, thinking I was overcomplicating things =COUNTIFS({Approve Date}, >=[Week Starts]@row, {Approve Date}, <=[Week Ends]@row,…
How to Automatically Checkmark a Column for entries that are created within a time-based timeframe
I'm trying to write a formula that will automatically place a checkmark in a checkbox column titled "Today Entry" whenever entries meet the "Created" column criteria of being submitted after 1100 AM the day prior and 0800 AM today on a rolling basis: I've been trying to use the below column, but honestly I have no idea. I…
Calculating the total duration from a date & military time start and end
I have been looking at a lot of information on this site and this is the closest one I have found, however it does not calculate the minutes correctly. For example instead of 8hrs and 45 min it gives me 9hrs and -15min. Formula: =(([On-Site Date]@row - [Notification Date]@row) * 24) + VALUE(LEFT([Time of Crew arrival]@row,…

Metrics

Answers

Help Article Resources

Categories