Move a cell in the same sheet and make it a sub-task


Dear Community,

My primary column is a Project Name. There is also a column called "Location." My objective is to add a new line (manually or through the form) to the sheet and then let Smartsheet sort it and put it together with the other lines with the same locations. I would also like to make it a sub-task to the first line in each location

Is it possible? I have read about copying cells to another sheet, but this would be too complex for my users.

Best Answer