-
UPPER formulas
Is there a way to set a formula so all text in the column or sheet is upper case even if someone enters it on a form in lower or title case?
-
Requested Area On Form
Hi there ; I would like to get your ideas abot my below issue ; i have a form , in that form i used some columns from my sheet , forexample there 3 columns , named "request 1" , request 2 " ,request3 , is is something possible like that ? on the form normally there will be only "request1 " field but on the form there will…
-
Data storage EU
Hello! I'm afraid my question is not a new one, but I'm not giving up hope that Smartsheet is interested in expanding into Europe. Since I realized, that EU-GDPR seems to be accepted, the IT-data-security-departments at my Clients in Germany are still focused on where Smartsheet stores the data. Tha is top level of…
-
Can I export, download or create a report that contains the labels and helptext in forms?
I use forms a lot in smartsheet. The column name is too short so I use the label for each question. Is there a way to export or download that information? Currently I spend a lot of time copy and pasting this info into a separate sheet.
-
Is there a way to override existing data with a new form submission?
I have a form that is updated by users on a quarterly basis, and that data feeds into a dashboard. Is there a way to override existing data with a new form submission instead of creating a new row of data?
-
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…
