Might be a good use case of the new single value column where you can grab the previous row dynamically. Would involve one spreadsheet formula to create row numbers. Math column to subtract one from the current row number > single value start from that math column to grab the previous entry. More math or if-then-else columns to make comparisons.
Single Value Column Updates
1 Like