Paste as Values Automation/ Function

Options

Hey all,


I'm wondering if there is some way to automate the pasting of cells as values across entire columns or sheets. We currently have an archiving process that involves rows on an intake/tracking sheet and another "roster file" associated with that row. These two things have cell links between them but need these links turned into static values when archived.


For the row coming from the tracker to an archive tracker, this process happens organically. When a row is moved from one sheet to another it seems SS automatically converts all linked cells to values.

I would like some way to do this for the roster files as well... for this the links are in a column rather than a row. WCS we just copy/paste as values during the archive process... but the rest happens through automation so it would be a major bummer to have to leave any part of it manual.


Thanks!

Josh

Best Answer

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

    Hi @Josh Reed

    I hope you're well and safe!

    You could add a section in the sheet to format them to be on a row, or you could add a so-called helper sheet and cell-link them to a row and, in both cases, have them copied over to the sheet where you need them to have the values stored.

    Would that work/help?

    I hope that helps!

    Be safe, and have a fantastic week!

    Best,

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

    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!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

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

Answers

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

    Hi @Josh Reed

    I hope you're well and safe!

    You could add a section in the sheet to format them to be on a row, or you could add a so-called helper sheet and cell-link them to a row and, in both cases, have them copied over to the sheet where you need them to have the values stored.

    Would that work/help?

    I hope that helps!

    Be safe, and have a fantastic week!

    Best,

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

    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!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:andree@workbold.com | 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!