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
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 202 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!