Hi everyone, first day on Airtable. I am currently transitioning my spreadsheets from Excel.
Basically, I have two records with the same field (Trip #) with unique data in each record. The unique data that i am trying to compare are the odometer readings and determine the exact miles that were driven from the pickup of record one to the delivery record for record two.
I changed the Trip # to a date format in attempts to use the “is_same” function but it keeps returning the individual mileage for the each row and not an aggregated total of the odometer readings into the loaded miles field.
Thank you in advance for any help or insight that you might have.