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
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!