Remove links from copied sheet?

Brian W
Brian W ✭✭
edited 12/09/19 in Smartsheet Basics

I have a sheet that pulls some information from a master sheet using an INDEX/MATCH formula. Is there a way to make a copy of this sheet and retain the contents of the cells without the formulas?

Basically, I want to make an archive of the current state without it updating in the future to new information if the master sheet changes.


  • Brian W
    Brian W ✭✭

    Okay, well I figured out an inelegant solution, in case anyone has the same question.

    First I made a copy of the sheet to recreate the columns, then deleted all the rows from that sheet. Then I selected all the rows in the original sheet and used the row action Copy to Another Sheet, which copied all the values to the new sheet except the Predecessors. Then I copied the Predecessors column and pasted it into the new sheet. 

  • Lewis Speak
    Lewis Speak Employee
    edited 12/04/18

    Hello Brian,

    Thanks for getting in touch, I'll be happy to help with your query. 

    We currently don't have a programmed functionality for exporting a sheet whilst retaining the current value of data obtained via formulas, but I've let our Product team know about this request. We appreciate your input! 

    Let me know if you need any further assistance.