Each time I add one more row to one sheet (Sheet A), I want to trigger the addition of 7 rows to another sheet (Sheet . The data in the 7 rows will be driven off of 2 sheets (Sheet A and Sheet C). Sheet C is a static lookup table. Is this possible?
It's not possible natively within Smartsheet. You might be able to use a third party tool like Zapier to do this functionality but I am not an experienced user and will have to step aside to allow other community users to address this possibility.