Enhance the VLOOKUP function to take a date, using it to lookup the value in the cell history
Sorry if this is a duplicate. I can see the Idea that I created earlier today in my notifications. It states that the status has changed. But when I click on it (https://community.smartsheet.com/discussion/102567), it says the discussion can not be found. So, here I go again....
We have % Complete and Ranking (Top 20, from 1 to 20) as two cols in a grid. We want to report on those over time in another grid. For example, the current % and ranking now, those values one month ago, two months ago, and three months ago. Now is easy, using VLOOKUP. Looking them up in the past is manual -- one month ago, two months ago, three months ago. I go to the % Complete and Ranking cell for each row, and view the cell history, and determine what it was one, two, and three months ago.
Instead of manually, this new idea is that VLOOKUP take an optional date parameter. If the data is specified, it would lookup the value on that date.
Here is an example of how this feature would be used. In the following grid (a stalled roadmap item report), cols 2, 4 and 5 use VLOOKUP today. The highlighted columns, 6 thru 11, are manually looked up using the cell history on the same cells as cols 4 and 5. With this enhancement, cols 6 thru 11 could also be looked up using the VLOOKUP, supplying the desired dates: one month ago, two months ago, three months ago.
Thanks for listening, and I hope this goes through this time. Peter Spung
Comments
-
Hi @Peter Spung
Your request has been merged onto this Idea that's already been created, in order to gather votes in one place and bump it up the list!
Enhancement Request: access values stored in cell history
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives