Adding %Complete back to smartsheet

andrew.r.bridges45571

I accidentally deleted the %complete column in my smartsheet. How do I insert it back into the project? I don't see a quick way of doing this.

Find more posts tagged with

Formulas

Cell linking

Comments

Chris McKay

Hi Andrew,

While it won't bring back any of the data you had in the column, you can simply add a new % Complete column, navigate to the Project Settings window (via the gear icon in the top right) and then selecting the column you just created from the dropdown list under % Complete column.

Kind regards,

Chris McKay

Alison

Hi Andrew and Chris,

I also wanted to let you know that you can always write into Support and ask for a checkpoint of your sheet; an agent will be glad to send you this in Excel format and it should have data that you can copy and paste back into your sheet.

Please note that the checkpoints we have available only contain the grid data and Comments (on the second page of the workbook) and won't be as comprehensive as any backups that you make as your backups will also include a compressed file of attachments. If you haven't yet started performing backups, I recommend doing so to assist in case of future accidental changes or deletions. If needed, instructions for this are available in our help article on Backing up your data (http://help.smartsheet.com/customer/portal/articles/506499-backing-up-your-data)

I would also highly recommend setting up some periodic recurring backups via the steps at our Help Center here.

Kind regards,

Alison

Smartsheet Support

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…