Automatically reference cell above, roughly 5 cells above will have a = from another cell.
Hi There,
I was wondering if there was a way reference the cell above automatically, then on every x amount of rows have that automatically reference the cell to its right.
We’re trying to do this so that we can create an autodate column essentially so when a new row is inserted it will place the date there from the locked row that might be 4 or 5 rows above.
I know this isn’t the conventional way of using dates and sheets, but we’ve built a pretty cool solution to fit our specific needs, besides this one bump.
Here's an example of what Im referring to;
Whenever someone inserts a new white row into a "day", it will automatically pull the date (text) from the white row above it. the black/grey day rows will automatically pull the date (text) from the cell in Field Notes, on that row.
Thanks heaps!
Answers
-
Are your white rows indented by chance?
-
@JamesB They aren't indented - Unfortunately we can't utilise the indent due to our use of the reports.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!