Forms -

Barry Pruett · 05/12/21

How do you set up a form to fill in columns and not rows? Is that possible

Mike Wilday · 05/12/21

Forms are not able to submit down a column. Forms are designed to submit one row per form submission. What is your use case? I'm intrigued.

Mike Wilday · 05/12/21

Forms are not able to submit down a column. Forms are designed to submit one row per form submission. What is your use case? I'm intrigued.

Barry Pruett · 05/12/21

Use case is....

I have a list of metrics that we track on a monthly basis. The tasks are in Column 1 and the months are in row 1 at the top of the sheet.

Andrée Starå · 05/12/21

Hi @Barry Pruett

I hope you're well and safe!

Not sure I follow.

How would you use it?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Mike Wilday · 05/12/21

Interesting. I see. What if you made the month a dropdown selection in column one and then each column was a different metric? Then each month you could submit the metrics via the form and track it horizontally? Would something like that work?

Mike Wilday · 05/12/21

Smartsheet is a little different than excel or google sheets in that you can name each column and create different column types. The headers aren't stored in the actual cells they exist outside of them and those headers are the key to calling specific columns when doing formulas. Does that make sense?

Barry Pruett · 05/12/21

Yes, that could work. Its another team members sheet that collects the information from 20 people. I was trying to create a form so the manager could automate the sheet

Mike Wilday · 05/12/21

That makes total sense to me. Does each team member enter their own set of metrics or do they each own pieces of the month's total? For instance, does each member enter all of the metrics for themselves? or are members responsible for only certain metrics?

Barry Pruett · 05/12/21

The team members are responsible for their numbers that get rolled up to a final number. I think I've thought of a work around. Appreciate the help

Mike Wilday · 05/12/21

Sounds good. You can do a countifs where the month = x and the then count the numbers for each month in a final report. OR you can set up a report that groups and sums the totals in the report itself.

https://help.smartsheet.com/learning-track/best-practice-webinars/reports

https://help.smartsheet.com/articles/2482082-configure-grouping-to-organize-results-in-report-builder

Forms -

Best Answer

Answers

Categories