Hello, I have an application in which we track the schedules of the company’s flights. My problem is this: I create the flight itinerary in a row within the “Flights” table. What I need is to create a cell in which to check if the previous flight was delayed, and therefore update the current value to the new schedule (that is, the scheduled schedule plus the delay time). The problem is that I don’t know how to reference the previous row. I tried with the formula LOOKUP() referring to the row number like this: LOOKUP(([_RowNumber]-1),Flight,_RowNumber,Registration) and thus compare if the license plate is equal to that of the previous row and this one was delayed, add that delay time to the scheduled schedule. Every time I try, the lookup() formula gives me error. I don’t understand how to work with a previous row in the same table.
