-
How do I get Datamesh to create new rows when lookup values match, but mapped columns have different
I've created a form which collects some common data, and then multiple requests, each with their own data. For example, I'm collecting the requestor's name, and 25 bits of data they want added into our system. The 25 bits of data all share the same properties, but it's very unwieldy to have all on a single row in the…
-
Appointment Booking Smartsheet?
Hi There, Just wanted to come on and see if anybody on here has created a booking system on Smartsheet either using a sheet or form. I would require to have a selection of dates with duplicated time slots (example. there would be 3 available appointments at 9am on Tuesday). I can't think of a way of doing this where the…
-
Creating assessment questions in forms and running into the column description length issue
Hello, I would like to create a form with a series of questions. I'm running into the issue where the length of the question is greater than 250 characters for the column heading. Has anyone figured out a workaround? Miki
-
Hyperlink URL and Display Text from two separate fields?
I have a Form entry that is asking for a (human readable) tag name in one field, and a hyperlink URL (non-smartsheet location) in another. I want to populate a single Smartsheet cell with the hyperlink pointing to the URL, but with the Display Text of the human readable tag... and I can't figure out how to make this…
-
Form -is there a way to display only available times (defined in drop down list) in the form
we are using a form to collect customer info and reserve timeslots.. is there a way to display only available timeslots vs the entire column of times in the drop down list
-
Can't add background image to Smartsheet form
I've easily added background images to Smartsheet forms in the past, but now I'm having the following happen: • I open the Edit Form window and click on Edit background • I upload the image (which is less than 5MB) and the image appears successfully in the preview • I click on Apply in the edit background window and the…
-
Limiting registrations in Smartsheet Forms
Hi, I have built a Form in smartsheets for an event. One of the fields (parallel sessions) has a dropdown list where participants can select the session they would like to attend. The problem is that I would like to limit the number of people that can select the options from the dropdown, so that whenever 25 people have…
-
Sorted column keeps resetting
We're using forms to gather requests into a smartsheet and the default sort should show the newest request first. There is a Created (Date) System column in order to sort by newest received but the sort continues to glitch each time the sheet is closed and it defaults to sort oldest to newest. This is creating some…
-
Cell Content Added to Conversation
Can an intake form field, or sheet cell content, be added to an existing or new row conversation?
-
Automated form
Is there a way for a particular cell in a preexisting row to get updated via a form or similar? IE a row already exists. A date is entered into column A which causes a form to go out to the contact in Column B and this form contains columns C, D, and E which contains drop down menus and star-rating columns that the form…