Formula to paste values generated by function

edited 12/09/19 in Formulas and Functions

I'm trying to figure out an automatic way to run a function in a cell, and have that function paste the value, and only the value, to that cell. I don't want the formula to continue to exist within the cell. Similar to if I copied the cells post calculation, and did a paste-special of only the values.

For example, =5+3 would set the cell value to 8, but if I enter the cell again, the =5+3 still exists. I only want 8. For my task however the data in the cell would come from a cross sheet VLOOKUP, and would be more than just a digit. Unfortunately the source data is constantly reorganized, so I need to be able to do the VLOOKUP and not worry about it updating with incorrect values.

In excel I've done this using VBA, with =SetCellValue(cell, value), but I have yet to find a way to do recreate this in Smartsheet.

Thanks for any help.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!