Replace Cell with the Value of a formula

Lee Joramo · 08/03/18

A common workflow for me while preparing data, is to use a formula to setup some cells and then to copy and paste the Values back into the same cells.

Excel allows you to copy, but to paste just the values. (NOT the formulas). Can this be done in smartsheet?

Andrée Starå · 08/03/18

Hi,

Yes. Copy the cell and then right click and choose "Paste Special" (CMD+Shift+V on Mac) and choose "Values"

Would that work for you?

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant @ Get Done

Lee Joramo · 08/03/18

Well that was exactly what I thought I had looked for and didn't find.Just like Excel

Thanks

Andrée Starå · 08/03/18

Happy to help!

Christina Eldergod · 05/08/20

Is there any way to automate this? Such as having another column that equals the result? Or a formula additive that would drop the function and just retain the value? I am looking to keep daily results but crews change daily so my results are changing by the day.

Let me know,

Paul Newcome · 05/08/20

@Christina Eldergod

The only way I have found to automatically capture data statically that was generated by a formula is by using either a Move or Copy Row Automation.

Andrée Starå · 05/11/20

Hi @Christina Eldergod,

The third-party service, Zapier, could be an excellent option for this scenario.

Is that an option for you?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Josh Reed · 03/09/23

https://community.smartsheet.com/discussion/comment/249418#Comment_249418

this.

IF you want the row to stay on the current sheet but still paste values automatically, I would suggest moving it to a helper sheet. Moving rows will automatically paste as values (works for cell linked data as well!) BUT it will also keep links intact. Then you have automation on the helper sheet to simply move it back. The only caveat here would be that the row will likely not move back to where it was and would instead appear at the top or bottom of the sheet. Likely a re-sort would fix this, if needed.

I employed this strategy for an Archiving system. We have many cell links and formulas in a sheet with over 200 columns (contract processing, grueling, horrible work really) and the data is incredibly important for regulatory compliance. In the past everyone had been manually pasting as values across the row and then manually moving it... I simply identified a trigger and then used the automation to move the row to an archive sheet and the rest is taken care of automatically.

Replace Cell with the Value of a formula

Comments

Help Article Resources

Categories