I am building an intake form and one of the questions asks for the make, model, and serial numbers of units. Sometimes there are 40+ units with different makes, models, and serial numbers. Is there a way that I can build in a question that asks how many units they are requesting for and then create a logic that displays an…
Hello, I am creating an item request/reservation form for check out/in of a limited number of headsets, 6 items. I am trying to determine a way for the sheet automation to look at the date a headset is requested and send a confirmation if that date is available for one or a denial if all six are already reserved for that…
Why is my form writing to my Smartsheet but leaving 40 or so rows blank? I am getting all fields populated correctly but a huge number of rows left empty. It's making a right mess!
Hello! Can we remove a time slot in the drop down on a specific date if it is taken. Below is an example. For example if someone Booked - Dec. 31, 2023 - 9:00AM - 9:20AM, can we automatically remove that from the drop down list since someone booked it? What are the ways?
This discussion has been merged.
I want 3 new multi-select options for forms. A form creator option to limit the # of options someone can select (e.g. pick 5 of these 12 options) An all-of-the-above option for the creator to toggle on, to let form respondents to select all options listed A none-of-the-above option for the creator to toggle on, to let form…
It would be extremely helpful to be able to add a data table to a form. I need to be able to ask users to provide details about, for example, grazing in multiple paddocks. My table would look like this: Column 1 Header: Paddock No. Column 2 Header: Crop Type Column 3 Header: Area Please add this to the list of development…
Hi, I have a column formula that grab a link from reference sheet and I need this to be displayed before submitting the form. Example, column A is a drop down of items, each of these items can be downloaded from a shared link. So in column B I added a formula to grab the link from referenced table. However in the form I…