-
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…
-
Form Users Being Required to Sign In
Hello, I have a form that's set so that anyone with the link can use it. However, some users are being required to sign in. Does anyone know what could be causing this?
-
Does anyone use a Change Management Form in project work and have a dashboard?
Hello. Our PMO is beginning to use smartsheet as our primary tool. We're starting with basics and have created a project plan template that also rolls up into a dashboard. We would also like to track change requests and have an overview for reasons, # of requests, # of date changes made due to requests, etc. Do any of you…
-
Best way to pull data from different columns into one
I have a worksheet that is populated via a form. Worksheet is currently 300+ columns wide (I didn't build it, I inherited it). The form is used by facility management technicians. Each time they go to a client site to service facilities, HVAC units, refrigeration units, etc. they complete this form. Yes, they complete in…
-
Logic Options Without Text Boxes
I am trying to create a logic in Forms of when an employee selects a location from the dropdown, the logic will display the address underneath without the need of a text box or check. Is something like this possible? Thank you for your time
-
Form will not save
When I click the open form link on the right top of the page it makes me save the form, which is great. But my form will not save, the little icon just spins. I've tried clearing the cache, restarting Smartsheets, restarting my computer, etc. Any help would be greatly appreciated!
-
Smartsheet Form Displaying Field in Scientific Notation
Hi all- I have a Smartsheet form that prepopulates from a calculated field Tableau. Previously, the primary field was populating just fine, appearing as a plain integer. This field is an integer in Tableau. Suddenly today after this form working just fine for a week, the field is displaying in the form in scientific…
-
Linking two sheets in a very specific way
Hello all! Like my title says, I am trying to link two smartsheets in a very specific way. I have a process in which I have individuals requesting support for specific courses this is tracked in one sheet. I then have a second process that hires people to provide support for those classes. Where I am running into trouble…
-
Could a form dropdown option inadvertently change when a user submits a Smartsheet form?
We have a form that includes a dropdown for a list of counties in Florida (single-select). My colleagues have mentioned that form submissions are coming through with the incorrect "county" dropdown option selected (all coming through as "Flagler" county). I initially assumed it was user error since the county being…