Update formulas to new sheet at once without Control Center

Hi everyone. I am hoping you can help me. I have a large sheet and with the new year coming up I have to recreate the sheet. I have a reporting roll-up sheet with lots of formulas and would like to replace all the old sheet reference names to the new sheet. I have tried Find and Replace but thats not working. I manually tried changing the name but keep getting Invalid Reference. I do not have access to Control Center. Can you anyone assist me on how I can update the formulas to a new sheet? Thanks Brian

Best Answer

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Answer ✓


    Try something like this.

    =IFERROR(IF(VLOOKUP([eTracker Number]@row, {CY23 eAPP Station - Background Investigati Range 1}, 2, false) = "", VLOOKUP([eTracker Number]@row, {CY23 eAPP Station (C) - Background Investi Range 1}, 2, false), VLOOKUP([eTracker Number]@row, {CY23 eAPP Station - Background Investigati Range 1}, 2, false)), "")

    Did that work/help?

    Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!