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.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Read from row above | 4 | 702 | September 28, 2020 | |
| Making a Change/Variation Column using previous row data | 4 | 296 | September 11, 2023 | |
| Add row with values from just above | 2 | 21 | March 20, 2026 | |
| Fetching data from a previous row using date | 17 | 128 | February 19, 2025 | |
| Choose last value in single value | 3 | 672 | August 27, 2020 |
Single Value Column Updates