If we have a smartsheet of data and want to say "if this column says AMA, copy it to a different she

bday2329

If we have a smartsheet of data and want to say "if this column says AMA, copy it to a different sheet" and still have it linked so when we update the original sheet, the copied sheet updates??

Mark Cronk

Hi @bday2329,

I don't think its possible to do bidirectional updates between sheets. You could create a report with just "AMA" data. Changes in the report post to the sheet.

Not sure this is of any help.

Mark

Mark Cronk

Hi @bday2329,

I don't think its possible to do bidirectional updates between sheets. You could create a report with just "AMA" data. Changes in the report post to the sheet.

Not sure this is of any help.

Mark

Mike Wilday

Here's more on Smartsheet reports.

https://help.smartsheet.com/learning-track/smartsheet-intermediate/reports

Andrée Starå

Hi @bday2329

If you want to copy a row to another sheet (already set up) we could use-cross sheet formulas and the new Column Formula to keep it updated as long as we have something unique we could reference.

Make sense?

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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

bday2329

Thanks can you provide an example of the formula?

bday2329

Here is what I have for a formula

In my copy to sheet I have a column formula of

=IF([Item Number]@row = {Item #}, {Col 3})

I am trying to check the copy from sheet by Item number and if a match is found use the value in column 3 from the copied from sheet in the copy to sheet

AAATESTSheet 2 is the copy to sheet

Andrée Starå

@bday2329

I hope you're well and safe!

Excuse the late response.

Did you get it working?

Be safe and have a fantastic weekend!

Best,

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