-
making options in dropdown unavailable if selected already
How to make dropdown options become unavailable (in both forms and sheets) once they’ve already been selected. Example: If a patient books an appointment, that time slot is automatically removed or disabled so it can’t be chosen again.
-
Easier and shorter "If" formulas
Ability to select a value from one dropdown list, and then have a second dropdown list display only a limited number of options based on that first selection. Example: Column 1: Zip codes (user selects a zip code) Column 2: Flu vaccine dates (only the dates available for that selected zip code appear as options)
-
Resize Image on Forms
Allow user to increase size of image on forms so that logos are more prominent and easier to read
-
Smartsheet forms (published) keep refreshing removing all data.
Hi, there might be a bug in Smartsheet. Recently, I have received many complaints from people across the company, telling me that every time they try to fill out my published form, their browser keeps refreshing for some reason. This has also been happening to me while I was providing some training; the form would refresh…
-
New entries to the Smartsheet don't include formulas
Hi all, New entries into my Smartsheet are not including the 2 formulas I have created. I have tried the troubleshooting which advised the following: Ensure the formulas are present in cells near where you want the new rows to appear. Check if the last row before the new entry is indented, and remove any unnecessary…
-
Form Submission / Vlookup Integration
Is there a mechanism to achieve either of the following scenarios: Individual populates form and choose a serial # from a drop down list. Can the fields on the form then use vlookup to auto populate the equipment's location from a master grid sheet on the form prior to submission? OR Individual populates form and choose a…
-
Basic Logic in Forms - Not working
Hi all, Im setting up a form, and what should be quite simple doesnt seem to be working for a logic request. I have a question midway through the form, if the user selects the anser 'Yes' from the dropdown (field A), a field appears to answer (Field B). If its a no, then the field stays hidden and move on to the next…
-
Possible work around for update request to apply a logic
Hi is there any work around to customize the update request like main form to put some logic and have a mandatory fields too ? and also is there any possible thing to do about on the attached files on attachment to view it on view only not auto download the file?
-
How can I show different dropdown values to different people in a Smartsheet form?
Hi everyone, I’m setting up a Smartsheet form for my consultants and need some guidance. Each consultant is offered different hotel nights, but I only want them to see the nights that apply to them when they complete the form. For example: Consultant A should only see the options Jan 10 and Jan 11 Consultant B should only…
-
How to update INDEX formula criteria in a specific way?
My company has created a freelancer invoicing system using two sheets. It depends on an INDEX formula that we now need to improve, which I'm having trouble doing. Sheet #1: A database with information on all individual freelancer (aka subcontractors) contracts (aka SOWs) Sheet #2: A form-based tracker with notifications…