Help

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

Freeze Rollup Value

Topic Labels: Formulas
100 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello
So I basically have a rollup tracking the amount of products ive sold in total, i was wondering if theres a way i can freeze the value in the rollup so when i delete a record that contains an amount of products sold it doesnt affect the value in the rollup.

so say i sold 5 items yesterday and 5 items today, the rollup would give me a value of 10, but if i delete the record that says ive sold 5 items yesterday i want the rollup to still give me the value of 10 and not just 5

1 Reply 1

Hi @Luyz,
You would need to add an automation to copy the result of the roll-up at a given point in time and paste the string to a text field. The copied string will not be linked to other records and will not change dynamically.