-
How to use a smartsheet to update the form dropdown values in another smartsheet?
I have a smartsheet that contains employee names and employee IDs. I would like to use the employee names stored in this sheet to update a form dropdown list of employee names on a separate smartsheet that tracks employee activity. I was going to use data shuttle, however there is not an upload data from a smartsheet…
-
Mobile number verification on smartsheet forms wont access Saudi Numbers
hi all, I have a form setup on smartsheet, where we require mobile numbers. Today there is an update on forms UI, apparently Saudi Mobile numbers are not accepted: Correct format should be: +966 50 111 11 11 Did anyone face such an issue? How can I resolve it? Many thanks in advance!
-
Text to Rows--Possible?
Hello, I've been all over the community forum and looking at various brilliant solutions, but can't seem to figure out how to do what I need. I have a form that has a field (Information) for a list of Number and Date entries. Instructions tell users to use a semicolon as a delimiter. I need to parse them into separate rows…
-
Can we submit attachments through forms?
We are working on a centralized calendar and love the File Upload feature in the forms, however, we sometimes need to collaborate on a shared document. This would require uplaoding a URL to the shared document. The File Upload feature only supports documents. Is there a way to add attachments to the form submission? Would…
-
How Can I trigger an email notification sent on a date along with a contact entered on a form?
I am trying to create an input form that allows an event to be entered, along with a date, if the event is recurring, and the contact to received the event notification. I am trying to do this using automation, but can't figure out if this is supported or not. Thanks for any help, g2smsht
-
Using forms to update current information in Sheets? Or another way to automate this process?
I have a form that we use to onboard new users. In the form, we would fill out information such as: contact name, position, department, manager, etc. Now, I want to use this same form and create a logic that would go something like this: Is the user "Current" or "New"?. So then the form displays certain fields depending on…
-
Schedule a Form to Send
It would be nice to set a form to send on a schedule at the form level instead of an automation on a sheet- then we could trigger the form to resend if it wasn't submitted within a certain time frame (say 3 days).
-
Table in Forms
It would be extremely helpful to be able to add a data table to a form. I need to be able to ask users to provide details about, for example, grazing in multiple paddocks. My table would look like this: Column 1 Header: Paddock No. Column 2 Header: Crop Type Column 3 Header: Area Please add this to the list of development…
-
Form - Number Validation - Allow Separator
It would be great if you would allow 1000 separator (,) when using the number only validation on a form. We have people entering very large values but also want to make sure they enter a number only. Not using the (,) separator makes it very difficult to ensure the correct number has been entered when entering numbers in…
-
Data Entry Suggestions for Siloing Data for Radar Chart
Hey everyone, I’m exploring the best way to use Smartsheet for collecting score card data and formatting it for a Radar Chart. Ideally, I’d like to: Enter audit results in Smartsheet Modify or structure the data in another sheet Format the combined data for visualization The goal is to merge audit percentages from the…