Copy Smartsheet Percent Complete Column - Preserve Formulas

Copy percent complete columns with formulas, formatting, and settings preserved.
  • Copy a percent complete column and keep its percent formatting and column formula so progress stays accurate.
  • Paste the percent complete column into the same sheet or a different sheet or region while preserving descriptions, widths, and system column settings.
  • Save hours each week on repeat tasks.

I'm going to show you how to copy and paste columns in Smartsheet. First, download SSFeatures. Open your sheet in Grid view. Select all of the columns that you want to copy. Right click one of the columns. Click \"Copy Columns\". Right click one of the columns again. Click \"Paste Columns\". SSFeatures will paste all of the columns for you. You can also paste columns between sheets. Open up the sheet that you want to paste into. Right click a column. Click \"Paste Columns\". This saves you a lot of time compared to doing this all by hand.
Use Cases
Reusing Columns Across Projects - When creating a new project sheet, quickly copy standard columns like Status, Owner, or Due Date from an existing sheet instead of recreating them.
Duplicating Complex Columns - If a column has formulas, dropdown options, or detailed formatting, you can duplicate it instantly rather than manually rebuilding it.
Cross-Region Sheets - Easily copy and paste columns between Smartsheet regions (NA, EU, AU) to keep workflows consistent across global teams.
Frequently Asked Questions
Simply select the columns you want, right-click and choose 'Copy Columns,' then right-click again where you want them to go and click 'Paste Columns.' The new columns will appear instantly with all settings intact.
SSFeatures keeps all column settings, including type, system columns, formatting, descriptions, widths, and formulas. This ensures your columns work exactly as expected in the new location.
Yes. SSFeatures runs entirely in your browser and never sends your data to external servers. All actions are performed locally using Smartsheet’s own code, so your data remains secure and private.
SSFeatures has a 30-day free trial, so that you can try out all of the features of SSFeatures. You don't need a credit card. Just download the extension and start using SSFeatures, then your free trial will start automatically.
No, you do not need to provide credit card information or create an account. Simply download SSFeatures, start using Smartsheet, and then the free trial will begin.
Yes, SSFeatures is very safe. Here's why:

1. Your data stays private. SSFeatures runs inside your browser. It never sends your Smartsheet data to any outside server. Your info never leaves your computer.

2. Your settings are stored only in your browser. This means better privacy. If you uninstall the extension, you'll need to set it up again, but that's a fair trade to keep your info safe.

3. No API key needed. SSFeatures works with the page you're on, nothing more.

4. We're a Smartsheet Tech Partner. That means we work closely with Smartsheet to make sure our tools are safe and helpful.

5. You can check our code. SSFeatures is available on Chrome, Edge, Safari, and Firefox. All browser extensions must pass strict checks, and you can inspect our code yourself.

Learn more on our Security Page.
Thousands of Smartsheet users across many industries use SSFeatures every day.
What is SSFeatures?
  • SSFeatures is a browser extension that makes Smartsheet way easier to use
  • It adds dozens of time-saving features directly into Smartsheet
  • It will save you hours of work every week

Are you tired of wasting hours in Smartsheet doing the same tedious steps? SSFeatures makes Smartsheet faster, smarter, and easier to use. It's a simple browser extension, packed with powerful tools that save you hours every week. Trusted by thousands of Smartsheet users with hundreds of five star reviews across Chrome, Edge, Safari, and Firefox. Save hours every week in Smartsheet! Try SSFeatures free today!
Hear what users say
"We wouldn't love Smartsheet nearly as much without SSFeature's PDF Generator!! Our business depends on printed Smartsheet reports. SSFeatures has allowed us to successfully continue scaling on Smartsheets without printing workarounds. Our team members that rely on our reports are way happier ever since we started using the PDF Generator. It's great to see there are 3rd parties willing to fill critical gaps in Smartsheet."
Ari Diamond
President of Railing Excellence
Star Icon
Star Icon
Star Icon
Star Icon
Star Icon
"SSFeatures has been a game-changer for our Smartsheet workflows! It’s super easy to use and adds powerful functionality that makes automation and reporting so much more efficient. The developer is incredibly responsive and provides top-notch customer support, making sure everything runs smoothly. It has saved us a ton of time and eliminated a lot of manual work. If you’re looking to get more out of Smartsheet, I highly recommend giving SSFeatures a try!"
Michelle Choate
Senior Manager of Operations at Impact Housing
Star Icon
Star Icon
Star Icon
Star Icon
Star Icon
"Finally found a solution to handle some of the features I have been waiting on for a long time... So grateful to SSFeatures for the Auto-Sort function that has dramatically improved our experience with DataShuttle > Update Dropdowns feature so they are always alphabetized. Column finding/hiding is awesome! Keep up the great work - saving me hours!!!"
Joe Morrell
Independent Consultant at Morrell Consulting
Star Icon
Star Icon
Star Icon
Star Icon
Star Icon
"I love that someone added features that Smartsheet seems to be unable or unwilling to add."
Ryan Ballew
Program Manager at Verizon
Star Icon
Star Icon
Star Icon
Star Icon
Star Icon
"PHENOMINAL app! A no brainer purchase for any Smartsheet super-user. Auto-sorting a sheet, printing or exporting a grouped/summarized report, SEARCHING FOR COLUMNS BY NAME! All in one packaged app that's controlled within Smartsheet. Amazing. Highly, highly, highly recommend."
Kayla Sweeney
Smartsheet Solutions Consultant at Better Work Week
Star Icon
Star Icon
Star Icon
Star Icon
Star Icon
"All the SS Features are great but for us the PDF Generator was a huge game changer, a large percentage of our work depends on printed reports and the support of PDF generation for smartsheet reports while keeping the grouping & summaries was a must have."
Leiby Hershkowitz
CEO of Superb Developers Inc
Star Icon
Star Icon
Star Icon
Star Icon
Star Icon
Get started in 2 minutes
Number 1 Icon
Click the button below
Number 2 Icon
Install the extension in your browser
Number 3 Icon
Start using Smartsheet
Related Resources
Smartsheet Column Copy & Paste Copy and paste entire Smartsheet columns between sheets to save time when replicating structures.
Duplicate Smartsheet Column With Locked Values — Save Time Duplicate Smartsheet Column With Locked Values with SSFeatures — copy locked values, formulas and formatting across sheets and regions. Try it free.
Paste Smartsheet Column With Text Wrap - Preserve Formatting Paste Smartsheet Column With Text Wrap - keep wrapping, formulas and formatting intact across sheets and regions with SSFeatures. Save time. Try it now.
Paste Smartsheet Column With Description - Preserve Metadata Paste Smartsheet Column With Description - preserve descriptions, formulas and formatting across sheets with SSFeatures. Save time. Copy columns in seconds.