-
Goolge translation thinks my form is in the wrong language
Hello everyone, I have a small but annoying problem. We are a French-speaking hospital and therefore our smartsheet forms must be in French, but Google seems to think every time that the form is in English and therefore tries to translate it into French (automatic translation of the browser on all our computers). This has…
-
Total Cost Based on Date of Task Being Finished
I am working on charting out dev tasks and need to display what our expected total monthly cost would be based on the tasks finished each month. I am struggling to find out a good way to have this either permanently displayed or easily accessible. I have tried reports but that only displays all of the costs and does not…
-
Forms in smartsheet with multiple variables
I want to create a form in smartsheet with several variables, each question has 3 categories and each category has 4 options, what would be the best way to do it? Thanks
-
UPDATE: Answered.Form changing a number entry to a % in the Sheet
ANSWERED - Found it from another post where RossL told someone to make sure the % sign wasn't selected for that column. Magic solution. Thanks RossL. I have a form with a question asking "What % of time will be allocated to this project?" When the answer to that question is populated in the sheet, it's coming through as a…
-
How to split text to support reporting?
Hi, I am bumping into a design / Smartsheet limitation issue. I use an request inventory sheet to track client change requests. CR are submitted via a form. One of the field helps tracking the category of the CR (business feature grouper). I had to concatenate 2 types of data to workaround the form and the fact that I…
-
Forms Workaround: Submit button opens new form to allow sub-info - How do I stop when user is done?
Please help! I'm stuck. Goal: Create a form customers can use to report a problem with an order. The order may have more than one line item (i.e. Customer ordered 5 received 3 of product #1-ABC and ordered 3 and received 5 of product #1-ABE, both on same order) I want the customer to be able to provide their contact…
-
Hiding form drop downs based on prior submissions
I'm trying to mimic a Qualtrics survey capability that enables the survey (form) to only show available dates that have not already been selected by prior survey respondents. Is there a way to accomplish this?
-
How to make a COUNTIFS Formula work
Hello, I'm hoping someone might be able to help me make a COUNTIFS formula work. Some background... I've set up a sheet that aims to capture a team's availability of staff in any given month, should their be a major event occur. The staff would complete a form that asks for their name, contact details, job role and their…
-
Forms -
How do you set up a form to fill in columns and not rows? Is that possible
-
formulas in a form
Hello, I've created a form with an email and a user name field. I would like the user name to default to the value entered in the email address field. Is there a way to use logic or formulas in the construction of the form to accomplish this? I realize I could use a formula in the sheet itself but wondered if it could be…