I want to provide a workaround solution given that Airtable natively cannot do much with the change log, and I want to create a column that would update another column (within the same table) every 1 or 2 days. For example, something like the below:
Column B = IF( Last Modified Date < Today - 1, = Column A, IF FALSE DO NOTHING).
Through this I am hoping that even though Column A is continually changed, I can see the previous value of Column A via Column B.
Thank you in advance, and please let me know if I should explain further.