How to to add a single cell of data to a new sheet?

System

This discussion was created from comments split from: Can I have just one cell automatically copy over from 1 sheet to others when a new row is added.

Adrea

I am having the same challenge/question. I have A LOT of data in my "Sheet A" and I really just want my Primary Column data to initiate a new row (only thing to come over) when any one of 4 columns are set to "no". Having all of those columns in my destination sheet will be a HUGE mess. Has anyone continued to explore and found a different way to add a single cell of data to a new sheet?

John_Foster

@System @Adrea

I do not believe this is possible, the copy process copies all rows.
The only way I could see this being possible currently is by using the Smartsheet API's and doing this outside of Smartsheet's automations.

John