Welcome!

Replace Cell with the Value of a formula

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?

Find more posts tagged with

Formulas

Comments

Andrée Starå

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

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

Thanks

Andrée Starå

Happy to help!

Christina Eldergod

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

@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å

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

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.

Sign in to join the conversation!

Quick Links

Trending discussions

Formula Not working adding a 0
Hello I could use some help with this formula. Here is the formula I am using the bright yellow column to hold the formula. so you can see the results of that formula below =IF(ISBLANK([Initial Approval Date]@row ), " ", [Homeowner Approval Initial Status intake]@row + [Homeowner Approval Initial Status Intake 2]@row +…
Date/ Time cutoff tracking
Hi there, I've created a sheet to where my team is tracking information received. In one column, we are logging the date and time information came in (ie: November 21, 2025 8:30 AM). I would like to add a checkbox column, with a formula specifying that the box be checked if the logged time is AFTER 8:30 AM, and left…
Join-Collect from dropdown?
I have a column named Territory, where I am trying to write a formula to populate it when names are chosen from an adjacent drop-down list column called Employee Attendee. If more than one name is selected from the Employee column, I would like their respective territories to populate in the Territory field, separated by a…