Freeze Rollup Value

Topic Labels: Formulas
542 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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.