-
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…
-
Best method for linking 2 sets of data together that use forms to collate the information?
I'm working on a project to help devise a solution to track all of our organisation's skills & talent initiatives, plus that will provide us with some useful metrics. The plan is have 2 forms - part 1 that collates all of the schemes' information and then a part 2 that collates information on outputs, but which is sent…
-
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).
-
Saving a "Form" for later use without submitting as of yet
I have employees that try to start filling out their form as they work their 8-hour shift throughout before submitting. It seems that there are times that they leave for a while, and it automatically shuts down without saving their information that they currently had in there. I heard that there is not a way to save the…
-
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…