Formula to paste values generated by function
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
Check out the Formula Handbook template!