-
dot and comma to separate dollar and cents
Some colleagues in US or other countries all over the world capture data via a form into Smartsheet. Sometimes cents are neeeded so the dot will be used to separate the dollar from the cent. My account is in Germany and the the Germans use the comma for separation not the dot. All data run into a failure and I have to…
-
Can I use a form to edit information of a register?
Hello to all of you! I'm brand new using Smartsheet and I could use a hand. Hopefully I'm not crossposting. :) We have a sheet with various fields. Sometimes we have meetings and we take a look of the values of one row at a time. That is sometimes exhausting because we ae moving back and forward, left to right to see each…
-
Is it possible to have a Start/End date on the same line?
I was created a request form for the office and I have to put a Start/End date option for this request. Would it be possible to have those options on the field line instead of different fields?
-
Issues with Form
Hello, I am having issues with my form: - When User fills out a form, they have to choose a department number from a dropdown. After the filled out form is uploaded into the sheet, the department number is changed? Example: User selects 577 in the form, but in the sheet it shows as 577.0 Here are some screenshots: The…
-
Form updates
I have build forms that have incorporated labels and helper text. I need a way that will allow me to resend the form with the labels and helper text and the previous answers in order to get updated information without requiring the user to refill out the entire questionnaire. The update request only sends the column…
-
Automatically Send Responses on Form
Hi, I have a Form that a variety of Managers use to input data. Is there a way to automatically send their responses on the Form to them after? Or do they constantly have to check the "send me a copy of responses" button each time they submit something? I tried to setup an automation for it, but I am not sure how I would…
-
Dropdown list with numbers
Hello, I created some sheet that is filled by other users by form. Form is based os single select dropdown list, like this one below: After submitting a form, there are some calculations made on those numbers. Until yesterday numbers appeard in that format: Now they appear in that format, so calculations cannot be made:…
-
Form completion checking box in sheet
Hi! I am attempting to have a box checked on a sheet after a linked form is completed. I have a established columns with a persons Name and want to have a column that has a check box when a specific form is completed by that person. However, the wall I am running into is that I a m having a duplicate row of information…
-
Is there a way to RECONNECT a form field to a column in the sheet? Feature Request?
So here's the scenario: You build a form and it creates the sheet automatically. Then, for some reason, you accidentally delete a column in the sheet. The form field still exists, but the column is gone. You recreate that column exactly like it was in the sheet, however, now the two are no longer connected. It'd be great…
-
Word Count Limitations?
I am setting up a form but need to limit the word count. I already built a formula in the sheets with formatting to identify when an entry has surpassed the 1,500 word count max but I want to limit it while someone is filling out the form so that I don't have to send it back for edits. Is there a way to limit the word…
