Question Math: get value from prior cell?

Hi,

Looking to give some up or down trends. This comes in from a form, so a new row, but in different groups. For example, all transactions go into one sheet and there are two groups. Each row has a price, and i want to show, after the form is entered whether that price was trending up or down?

Ideally, i would look to the prior cell, of that group, but I cant figure it out.

Hope I explained that ok.

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.

:wrench: Single Value Column Updates

1 Like