Creating a link that automates adding new cells into the sheet

PFI.Data.Specialist

On the current project I am working on, I am trying to use smartsheet to recreate an existing Microsoft Excel template that my company uses to collect data. At the bottom of the template, there is a cell that will create more cells at the bottom of the data set (ex. one region is working in 4 schools in quarter 1, but then expands to 6 schools in quarter 2).

Is there a way to create this automation within smartsheet, or is the only way to avoid the dilemma is to just include the extra cells on the front-end?

 

Andrée Starå

Hi,

Not sure I follow!

If you add rows/information to Smartsheet the rows will expand automatically.

Would that work?

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD