Remove Link but Keep the data

Options

Hi,

Is there to keep the previous data if the Reference if deleted.

I have this formula

=IF(vlookup(referencetoanotherSheer)=x, True). But if the other Sheet is deleted, I want it to maintain the value instead of showing #REF

Answers

  • Ramzi K
    Ramzi K ✭✭✭✭✭
    Options

    Hi @Bhargava Ram Kummamuru,

    Try Copy / Paste-Special Values.

    That will replace the link with the actual data values.

    I hope that helps.

    Ramzi

    Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)

    Feel free to email me: ramzi@cedartreeconsulting.com

    💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!