Referencing Relative Columns a Formula

bcirka

Scenario:

• I have a data set with a fixed set of ID numbers in column A.
• When my flow runs, numbers are captured in column C.
• When my flow runs again, the new numbers are captured in column C, and the old numbers are, by implication, shifted to column D.
• So every time I run the flow, a new set of values are captured in Column C, and the old snaps push continously to the right.

Here's the problem.  In column B, I'd like to have a formula to calculate the difference between Column C and Column D.  Is there any way to reference the RELATIVE columns C and D, rather than having to use a fixed header name within the formula tool?

Thank you!

Input:

Project ID	Latest Delta	Snap 2-3-23	Snap 2-2-23	Snap 2-1-23
ABC	3	0	3	7
DEF	4	2	6	9

ArtApa

@bcirka - Alternatively, you can do something like this:

RelativeAA02.yxzp