Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Mar 22, 2020 01:53 PM
Hello,
I have month end dates and product values. I’m trying to use the previous value in a formula. I started by trying to get the previous month-end date which I was able to get using a DATETIME_PARSE formula. My attempt to get the Previous Value hasn’t worked yet.
In laymen’s language, it would be something like:
Find the Value across the table where Date(in searched records)=Previous Date(in current record) & ProductID(in searched records)=ProductID(in current record)
ProductID is linked to a Products base.
I’m very new to Airtable and appreciative of any help. I tried to include a screenshot but my guess is as this is my first post it won’t let me. If I’m able to I will.
Thanks
Mar 22, 2020 11:05 PM
Hi @Mike_Johnston,
Welcome to Airtable Community !
If I understand you correctly, what you are trying to do is not doable in a direct way on Airtable. You cannot compare 2 values in the same field of the same table. However, there are many work arounds. Easiest workaround would be that you create a Linked field, link the 2 values you want to compare, in the other table use either lookup or rollup, and compare the values.
BR,
Mo