-
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?
-
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…
-
Dashboards are auto-refreshing every minute, but are set to refresh every 10. What is causing this?
Hello, I work to maintain the Smartsheet system at our company, and as of last Wednesday there has been an ongoing issue where dashboards that are set to refresh on a 10 minute interval are auto-refreshing every minute (or less), preventing our workforce from using the forms embedded on said dashboards as it cancels their…
-
Attaching my Smartsheet generated PDF
Good day! I've been successful previously creating automation for a worksheet that includes auto-generated PDF from a fillable form link and automated attachment of the PDF and successful send of the PDF to myself (my test email). Later I had to make some updates to the form, renamed the form, and revised some of the…