Remove Link but Keep the data

Bhargava Ram Kummamuru
Bhargava Ram Kummamuru ✭
in Formulas and Functions

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

Tags:
· Share on FacebookShare on Twitter

Answers

  • Ramzi K
    Ramzi K ✭✭✭✭✭

    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.

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!