-
Formula help - difference between two form submissions based on a couple of
Hello, I need assistance with creating a formula to calculate the time difference between two submitted forms. One form is submitted when a person checks in, and a second form is submitted when they check out. I'm seeking a formula that considers the date stamps in relation to the Site Address and Check-in Action columns.…
-
Dropdown List, "Allow Multiple values per cell", provide an option to "Limit number of selections""
When working with a Dropdown List, it would be nice to be able to limit users to selecting X number if we have the "Allow multiple values per cell" option selected. Here is a concept art of what I'm imagining: Of course you could leave the value blank or have 0 be "unlimited". This could then transpose over to Smartsheet…
-
Allow Forms to be Saved to a Workspace
Hello, I am submitting this idea/enhancement to allow forms created from sheets to be saved on their own (as forms) in a Smartsheet folder or Workspace. Right now, it can be cumbersome to get to the form.
-
Yay! Text formatting in Smartsheet forms
Smartsheet forms now have the ability to format text in the form title, form description, and field help text. Check it out and let us know what you think. Style (Bold, Italic, Underline) Text color & highlight color Bullets & numbering Justification (left, center, right, indent) Hyperlink
-
NEW! Form hyperlinks now open in a new browser tab
Hi Community! We've recently updated Forms so that hyperlinks will always open in a new tab. In order for this update to take effect, you'll need to navigate to your sheet, go to 'manage forms', delete the hyperlink, and re-add the hyperlink. Then click save and you should be good to go! With this update, you can also…
-
Creating an approval form from a submitted user request form
Hi, I have successfully created a form that allows a new user to provide their information, their requested access level, and their supervisor's name. When the new user submits the form, I want another form to be triggered and sent to the supervisor for their approval for the new user. Thus, the form would include the new…
-
Can I add a .png or .jpg to the form Description?
I am pretty sure the answer is no but I wanted to check to make sure I did not miss any thing. My form is in the side-by-side layout and the title takes up 1 line. I would like to add a .png or .jpg below in the description for users to reference as they fill out the form. I tried to drag and drop and to copy/paste the…
-
Contact List not Populating
Hello, I have created a form with a couple of fields that have the Field Type set to contact list, but when testing the form nothing populates in the field, it's as if it was set to text / number. Is there a way to have it auto populate as a user begins to type a name? Thank you.
-
Can you update form responses once it is submitted?
I am trying to see if my teammates are able to update their responses in forms once it is submitted? The reason being, they will get a request from the TL to report on quarterly updates. Once filled out, they will also validate that info with sponsor and update accordingly. We are simply utilizing Smartsheet to view the…
-
Is it possible to add more than one email at the end of a form?
On a number of forms, I am not the only person that should know that a form has been submitted; I was wondering if it is possible to add more than one person in the 'email myself' field at the end of an email. My current workaround involves forwarding the email notification to multiple people.
