-
Capturing data from a Magnetic Strip
I was wondering if there is any way for Smartsheet to capture or populate information if we swipe a card that has a magnetic strip? I.E. can we have employees swipe their ID badges and capture their employee ID number?
-
Specification sheets
I need to send out a form with default values and a corresponding field for the person receiving the form to fill out. I do not want to receiving person to be able to see the sheet the form was created from. Once the receiving person fills out the field I want them to send it back to me so their entered data will stored in…
-
Ticketing Sheet: Update Request to Group?
I'm using the ticket template and want to use the update request feature. Currently it seems like the only way to do an update request is to assign it to a specific user, which doesn't make sense if you have an entire department working on tickets at different times of day. How do you request an update to a ticket (row)…
-
Forms using drop downs
I read in an older post the when using forms you can only use values within the drop down even when "restrict to dropdown values only" is not selected. Has this been resolved yet by Smartsheet?
-
Auto Locking a Dropdown in a Form
We are trying to create a form or update request (not sure which would be best) that allows external users to select a date and time from a dropdown list and when one person has selected that time it then doesn't allow another person to select that time and disables it as an option. Is this possible with some sort of auto…
-
Can I show form users a calendar BEFORE having them fill out the form?
Hey, slightly complex question: my marketing department services several companies under our corporate banner, and we would love a way for end (form) users to see a calendar of scheduled communications before requesting a new one. We're hoping that showing stakeholders our already-full calendar of communications will…
-
Human Resources Time Off Requests with Functionality
Hi, I found 2 templates on smartsheets for time off, but neither work, and I have attempted to customize to my needs and I am not able to figure it out. First I want a form that employees can submit their leave, Second create a workflow for approval, and Third be able to tally the balances automatically to the appropriate…
-
Forms and formulas
Hello, I am new to Smartsheets and am creating a form to send out and collect orders from customers. Now the form works but I need it to populate the new rows that get added with pricing from another sheet. Is this possible as I am not finding any info on this but then again I am new to the site. I would also like to know…
-
Forms
Is there a way to make templates for Forms and then add them to each of our projects? I see where you can build forms and then clone them inside of a sheet but we would be looking to copy those forms into other sheets. Is there an easy way of doing that? Thanks!
-
Checkbox checked, cancel RYG
Hello, I have created 3 columns for the RYG, if the project is in the early stages the color green will show, if it is due within 4 days, yellow will show, and when it is due in 2 days red will show. Now I have a checkbox for the employees to click if the work is complete and I want the RYG colors disappear when they click…
