how can i keep all input data from a form in specific column in sheet

bob.amin110176

hi, i m new to smartsheet i created form where manager key in data but when i get data into sheet its not in specific order its based on when each manager when they enter.   i wanted each day n each value to be in same order 

bob.amin110176

here is example of excel sheet i have when change column name to store name n i create form it shows each store name as input field instead having input like store sales n deli sales n so on n on

Andrée Starå

Hi Bob,

Welcome to the Community and the wonderful world of Smartsheet!

There are a few different ways to structure a solution.

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

 

Andrée Starå

To add: It seems like a Workflow with an automated update request or a sheet structured thoroughly and maybe in combination with a report would be two optional solutions.

Andrée Starå

Did you get it working or do you still need help?

Have a fantastic day!

Best,

Andrée