Automatically transfer data entered in one sheet to other sheets.

Hello Everyone,

Does anyone know if it is possible to create a master sheet, then once a row is added to this sheet, the same row (With only specific columns) could be automatically added to another sheet(s) ?

Your help is Highly appreciated.

Thank you,

Hamza

Find more posts tagged with

Sales

Cell linking

Enhancement Request

Comments

Kyle Clopton

You can have a report automatically update the information it provides from any sheet. So in this view, if you have a sheet with a report and you add a column to the sheet, the report will reflect it.

Unfortunately, as far as I know sheets are not connected to each other in this way. The best that I can suggest is to create a template of an existing sheet that allows you to keep formatting and column information. I hope this helps, and anyone is welcome to correct me if I'm wrong!

Mitch.Shaffer

You might be able to accomplished this using Zapier.

J. Craig Williams

I second Mitch's comment.

I use Zapier for this a lot.

Craig

TJ-Webfoot

You use zapier for this a lot, Craig..? Triggered how? Zapier has very limited options for triggers.

CDKashork

Anything new on this question? I have tried Zapier and I think my request is too complicated or I don't have the right version of Zapier. When will Smartsheet be adding this feature internally. Frustrated...