Saving a formula generated value

Options

Hi

I'd like to ask if there was a way to save/store a value once it has been created by a formula, so that if the values that formula uses change, the value generated will stay the same i.e. the value and formula separate after the first generation.

The only way I can think would be to copy the row with the new formula to a different sheet, but would like to use as few sheets as possible.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!