How to mirror cells within the same sheet

SofiaPerez
edited 06/15/22 in Formulas and Functions

I'm trying to have to two columns with the same information. One of them should be used in the update request forms and be available for edit in the form. The other one will be used with the predecesor tool and remain hidden (to avoid having two columns with the same information in the sheet). This one should reflect the information from column #1.

I've already tried with cell linking (only available for two different sheets) and Index + Match formula (also for different sheets)

Tags:

Answers

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @SofiaPerez

    Are you looking to have these cells mirror exactly what's in the other column for that row, even as it changes?

    In this instance I would use a simple formula to reference that exact cell in that row, like so:

    =[Column 1]@row

    You can make this a Column Formula. This would then bring in the exact content from Column 1.

    See: Create and Edit Formulas in Smartsheet

    Cheers,

    Genevieve

  • That worked to mirror the cells, but the copied columns cannot be used with the predecesor tool.

    Thank you Genevive!

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @SofiaPerez

    Ah, my apologies! I didn't realize you're looking to have these locked in with Predecessors. Depending on what columns you're trying to mirror, this may not be possible, as certain project settings columns have to be manual entries in order to work with dependencies. These same columns also are not able to be updated via Update Request, as you've found.

    I would recommend setting up Conditional Formatting in your sheet so that if the updated cell doesn't match the actual column you're using, both of those cells light up in an obvious colour. That way you can manually copy/paste the information that came through the update request to the appropriate column.

    Cheers,

    Genevieve

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!