-
Can I display a field in the form based on 2 criteria?
I want to display a field if 2 fields are selected. Here's the use case. Field 1 : Year 2021,2022,2023 Field 2 : Department IT,Finance, HR Field to display - 2021 Finance Budget but only if 2021 AND Finance are selected.
-
How do you link certain information from a form to a sheet or report?
I am trying to link certain information from a form to another sheet. The form is a questionnaire with a Likert scale from 1-5. If the user select a 1 or 2, they are required to put in a comment. The comment is another question which shows as a column on the sheet. And lastly, the user who is filling out the form will…
-
I'm trying to create a form to be used to evaluate if a product is acceptable or not.
I'm trying to create a form in Smartsheet that would look similar to this below. Is this even feasible at this point with Smartsheet? First column is the product being evaluated, and we are asking clinicians to check either acceptable or not.
-
Forms - can you make formulas on dates?
can the sheet have a formula when the form selecting a date - gives a response? =IFS([@Response]="", " ", OR(WEEKDAY([@Response])={1,7}), "That is a weekend date. Please select a different date.", OR(WEEKDAY([@Response])={2,3,4,5,6}), TEXT([@Response], "dddd")) where the form entry will prompt a new suggestion?
-
ENHANCEMENT REQUEST!!
I created a scheduling system using a grid/form/dashboard. After implementation I found out that forms do not have any permission settings. Ex. I had a grid/form that I only want 10 people to access, the grid is restricted but everyone can access and submit using the form. For this project to be successful, I either need…
-
How can I send someone a copy of the form they submitted, INCLUDING the description areas on form?
I am aware of how to send someone a copy of their responses. I am seeking how to send them a copy of the description areas on the form as well. ie. how do I send them a copy of the form that they viewed as they were submitting it, along with their responses?
-
Is it possible to see which form was for entries on a sheet?
I can't figure out how to use a sheet with multiple forms and then how to tell which entry was submitted using which form. For instance, I am sending out 6 different forms that all belong to one sheet. These forms all of slightly different information on them. Then, those people all respond and I have a sheet full of 20…
-
Conditional logic in a form
I have created a form with conditional logic. The logic displays "catalog responsible" (column was previously set as contact list) and it is displayed only if the previous field is selected with "prod" option (column is set as dropdown) The form works perfectly, but since other group of persons will have access to the data…
-
Form response adding up to exactly 100%
Hi there, I am creating a form to track employee time against projects. I have created individual drop down lists (10%, 20%, 30%, up to 100%) for each project. I want an error code to pop up if employees responses add up to more or less than 100%. Is this possible? I believe Rick had a similar question here-…
-
Smartsheet App Barcode Scanner
Anyone out there find the barcode scanner on the app, particularly into webforms SUPER sensitive!? We've just started using a product expiry system in smartsheet which requires those receiving orders to scan the product barcode into a webform and enter the expiry date, qty etc. Then once that goes through to a 'landing…