-
Barcode scan into a Dropdown cell on a webform
Is there any reason why when i change a column to dropdown format, the barcode scanner doesnt show up for that cell in the webform? We have team members scanning a product barcode into a webform on delivery to record the expiry date. Due to the sensitive nature of the scanner, and some team members not being as particular…
-
Can I have a field only show when multiple criteria are met in different fields?
I see how to have fields shown based one field or multiple fields with "or" statements but I'd like to only show a field based on multiple fields having certain values or using an "and" statement. Something like: If Field 1 = A and Field 2 = Z then show Field 3. Is this possible or does someone know of an easy way to do…
-
Running Balances for employees
Hello all, I am trying to make a spreadsheet that tracks employee fitness reimbursement balances based off of their entries into a form. Each employee has exactly $300 that they can use per year for fitness expenses. Every time they submit a reimbursement, it gets put into a form that includes their name, clock ID, date,…
-
Link to form asking to create an account
I have deactivated the option on a form that requires people to login to smartsheet to access the form, then copied the link and made it a QR Code, but when the QR code is scanned on an iphone, it takes you through the process of creating an account. What am I doing wrong, please help.
-
Can you use a form to allow users to select available time slot
We are trying to utilize a smartsheet form for recipients to select a time slot for a specific training we are doing. We are offering a training to some internal folks but are limited in seats for each session. There are 12 sessions, some on the same date just at different times. Will use form to - * Allow recipient to…
-
Forms - Access control and security
Hi all, Is there an add-on or any plans to create an access control process for forms? Currently the only security setting is that users should log in, but that means anyone with a Smartsheet login. We need to be able to set access for forms like we can with sheets or workspaces. Given the new GDPR laws and requirements,…
-
Requesting update to specific people and only linking their projects
I'm keeping a portfolio of my teams projects (150+). Once a week, I'd like to send out a request update for each person to update their assigned projects. I can't figure out how to send out the request update only to those linked to their projects. As an example, I added a condition that if Project Led by was "my name"…
-
Request A Weekly Update Forces 50 Rows of Update. Only Need to Update First Row
HUGE issue. I have a workflow to request an update every Thursday. When workflow is triggered, instead of having only ONE row update, it asks for 50!!!!! This is bad. I tried to lock these rows but still is launching 50 pages worth of request update. ONLY ONE ROW should ever be requested. Period...
-
How to create a deadline column for it to be three days before the deadline that was put in the form
I am trying to create a workflow (I think) that when someone completes my form and enters their requested deadline in the form, there will be an automatic column that will show three days before that deadline requested. I want that date to automatically show three days before the requested deadline so that we can get…
-
Auto Reply to Form Submissions
Hello Team, I was trying to setup automatic replies to people who enter their email and select a certain timeframe. I would then like to send an automatic reply with information regarding the session that they signed up for. Is this possible using workflows? I can't seem to select a contact in the "Send to contacts in a…
