Create cell reference based upon horizontal axis position
Is there a way to create a cell reference based upon a horizontal axis? For example, for a given column, I want it to always represent the cell directly to its left.
For this example scenario, a new column will be added for every date and the new results will be entered into that column - Since the new date column will always be added directly to the left of the "Most Recent Assignment" column, I want the cell reference to dynamically update based upon any new columns that are added.
The purpose of this is to maintain a report that is generated on this column
Note: The structure of the base sheet CANNOT be changed - New dates must be created as columns.
Figure 1 - When creating the reference, it maintains the column
Figure 2 - I want the "Most Recent Assignment" to now reference the 10/26 assignment.
Is this a possibility?
Help Article Resources
Check out the Formula Handbook template!