Skip to main content

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

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

Reply


Terms & Conditions