Cell linking data from new row daily

I am wanting to link a cell from a sheet where each day a new row is added within the same column heading. Example: staffing numbers are reported each day in a new row.
What should I enter in the destination cell so each day the new row, but same column, data is entered?
Or is cell-linking not the right approach?
Answers
-
@rogerton I don't think cell linking is the right move here. I would use a helper column titled "Recent Date" that would use a MAX function to pull the most recent date of entry (assuming this is only updated daily)
The MAX formula might look like this, the {} brackets indicate a cross-sheet reference.
=MAX({Date Submitted})
Then I would do an index match formula to pull the staffing numbers associated with that date.
=INDEX({Staffing Numbers}, MATCH([Recent Date]@row, {Date Staffing Numbers Submitted}, 0))
Hopefully this makes sense! If you submit multiple staffing numbers each day you might want to use a unique ID in the source sheet instead of a date column.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives