Help

Creating a column that updates every few days

Topic Labels: Formulas
Solved
Jump to Solution
1147 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Andrew_Kim
4 - Data Explorer
4 - Data Explorer

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.

1 Solution

Accepted Solutions
Kamille_Parks
16 - Uranus
16 - Uranus

A formula wouldn’t help you much because it wouldn’t ever show you previous values. However if you set Column B to a text field you could use an automation to append Column A’s value to Column B once its been a day since Column A was last modified.

See Solution in Thread

1 Reply 1
Kamille_Parks
16 - Uranus
16 - Uranus

A formula wouldn’t help you much because it wouldn’t ever show you previous values. However if you set Column B to a text field you could use an automation to append Column A’s value to Column B once its been a day since Column A was last modified.