Use Sheet to complete Summary sheet or vice versa
Hi everyone:
I'm trying to figure out how to have information populate a grid from the summary tab or for the Grid to update the summary tab. The reason I am needed this information in the summary tab is that I am linking this to some dashboard widgets that I need to change as the project changes. If I'm entering information into the summary tab,
I want it to add a new row having the former row status change from current to past and the new row to be current with the information added.
I appreciate any help.
Answers
-
The first thing I would do is set up a System Date Created Column in the sheet. This will automatically log when a row was created, so we can use this as a reference point to find the MAX date (or most recent date) to bring back data from.
Then in your Sheet Summary, you'll want to create one new field per column that you are looking to report on. In this field you can then use an INDEX(MATCH(MAX formula to find the MAX date and bring back the most recent value from that column.
So, in your Status field in the Sheet Summary, you could use something like this:
=INDEX(Status:Status, MATCH(MAX(Created:Created), Created:Created))
Then for the Date, make sure you create a Date type of Sheet Summary field, and use this:
=INDEX(Date:Date, MATCH(MAX(Created:Created), Created:Created))
Let me know if this works for you!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives