I am wanting to create some order form for my company, but i cant seem to be able to create a section where they are able to put in more than one product at a time. What colunm type would i use?
Simply use the new Drop Down (Multi-Select) Column Type to make this work. This was a new enhancement announced during Engage '19, and it works wonderfully.
Smartsheet Overachievers Alumni
To add to Deanna's excellent advice.
Another option could be to use forms. One form for the primary information, and after it's submitted another form opens up where you can add each product. (the product form reloads after each submission)
Would that work/help?
I hope that helps!
Have a fantastic week!
Workflow Consultant / CEO @ WORK BOLD
✅Please help the Community by marking the post that helped answer your question or solve your problem with the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
What about a stationary order form?
The multi option wont work as i dont have a list. (or want to create one)
If the form refreshes is that a little cumbersome? But i will give this a go and see how the office handles it.
Thanks for your help.
Happy to help!
Re. Stationary Form.
There are several options.
The form refresh is almost instant so that shouldn't be an issue.
Let me know how it goes and if you need more help!
Thanks i will give those options a try.
Appreciate you help.
Let me know how it goes!
✅Remember! Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. It will make it easier for others to find a solution or help to answer!
Hi, Does anyone know if there is a way to send an alert if the value in a cell changes by more than a certain percentage? So, if I have 100 in a cell (text/number) and the value changes by over 5%, I'd like to be able to send an alert. Thanks, Vince
I'm sure this is super simple but myself and a colleague could not figure it out. I have some very simple data I need graphed for a project: Not Started, In Progress, Complete and then % Complete using the total. The pie chart for the Not Started etc. comes out correct: But when I ask it to graph just % complete, it does…
Hello, I am working on a training log for our company. I am trying to get the status color to turn green if training is completed, yellow if it is due in the future, and red if it is incomplete. I keep getting an incorrect argument. I had it working correctly when I was just doing red and green, but I really need that go…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.