Creating a link that automates adding new cells into the sheet

PFI.Data.Specialist
edited 12/09/19 in Smartsheet Basics

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?

 

Comments