How to mirror cells within the same sheet

SofiaPerez

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)

Genevieve P.

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

SofiaPerez

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

Thank you Genevive!

Genevieve P.

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