copy row from one sheet to another by using the formulas of the new one


Hi @ all, 

I haven't found any solution regarding by topic within the community articles. So maybe there is a smooth and easy solution for my question. 

We set up 8 identical sheets (formulas, rows) with a lot of fomulas. Why 8 sheets - because the maximum of a smartsheet sheet is by 5000 rows. ;) 

So if we would like to copy one row to another sheet the formulas of the new sheet wouldn't be used. Instead of that only the values of the row are copied. Therefore I can't add new rows in the second sheet because the formulas aren't inherited as well. . 

Thanks for your help and best regards,