-
Split Multiple Selections In Single Form Into Individual Columns
If I have an option on a form for a multi-date selection field is there a formula that could help break out each date selected into its own column. So if it was a sign up form and they wanted to select 3 dates to work then each date they are working could end in its own column. Then I could set a reminder automation based…
-
How to restrict Form responses to data existing in the related Sheet
I am trying to create a Form that requires the user to supply information related to any item existing in the Primary Column. If I pull that existing field into my form, the user entry is a free-form field and I can't figure out how to restrict it (other than validating by data types). If I add a new field with a dropdown…
-
Form with multi drop down answers - need help to count correct choices
Hi All, I have built a post training test form for a colleague, some of the questions have got multi answer choices (e.g. correct answers can be A, B, C, D or even choice of E - stating that all previous choices are correct; or could be that A,C,D are correct). If correct choice is chosen, needs to return point 1 per each…
-
Utilising multiple forms on one sheet
Hi everyone, I have a project where I need to build a very large form from 2 old ones we currently use. Is there any way to copy each form and run in the same sheet so that my work reduces as I can just then edit, remove and adapt rather than start this large form from scratch? At present I know I can copy one sheet and…
-
Merge multiple forms into a long one
It would be great if we could copy a form or sheet, but do this for more than one to combine. My current issue is creating a new and very large form, but taking parts from 2 old forms, if I could copy these forms into 1 then it would take a huge amount of work away. As it stands, I will have to recreate both forms over a…
-
Multiple Entries of The Same Name Into A Single Row
Good morning, I am newer to Smartsheet so forgive my lack of knowlede. I have created an attendance tracker form to track employee call offs from for our supervisors. Is there a way for example if John Doe calls off 3 days but each day is a separate submission due to different supervisor working, if each of John Doe's call…
-
Drop Down in Forms
i would like to know if its Possible to have the Same Drop Down in 3 different Forms that get filled out. but the Kick is i would like only to Show some of the Items in the Drop down in each Form. but i am looking to keep it to only 1 Drop down for the Main page that holds the information. and i its going to be a long…
-
How do I set a form logic to exclude weekend?
How do I set a form logic to exclude weekend in such a way that when the Date Created falls on a Friday and the Date Required is on Monday (next week) that it will show a hidden text field (to justify the urgency)?
-
Can input from one form separate to two rows when they input to sheets based on conditions?
We currently ask people to select one form per one need for referral into a program. For example, I want to submit a referral to a community health team and another one to behavioral health team. I need to submit two separate forms because each form submission will create one row to master task list where it then auto move…
-
Split Multiple Selections In Single Form Into Individual Rows (Core Product)
There have been a number of people asking how to make multiple selections in a single form and then have those selections broken down into individual rows, and the previous answer was always to use a 3rd party app, a premium add-on, or the API. Below is a set of detailed instructions on how to accomplish this within the…