-
Logic - Can you define if text in entry then show x field, as opposed to number?
Hi all, I would like a field to show an error message if anything other than a number or a decimal place is entered, so no other characters. Is that possible? I'm assuming I can't use regex within the contains logic? Thanks in advance
-
Automation > Action Block : Create a new Grid sheet from a template
Is it possible to trigger an action block that will create a new Grid sheet from a template? I'm trying to create an automation wherein if a new row is added to an existing grid sheet it will trigger the creation of a new grid sheet from a template and copy the details of the new row.
-
How to get a number of form submissions within a date range.
I'm looking to put together a dashboard and on it I would like to display a number. We collect work requests via form fills. Each form fill creates a line in my sheet. And I would like to be able to report things like 'how many form fills did we get last quarter'. I know I can filter my sheet to show just the rows that…
-
Copying Rows To the Top of Another Sheet
Hi All - Is there any way to use the Copy function, from one sheet to another, and have it copy to the Top of the sheet it's going to?
-
Control for Character Entry on Form
Hi there - Is there a way to control the characters used for a form? I would like to limit to just roman letters. If this isn't possible, a suggestion for a work around on the grid? ie. We have event rsvp that are entered in Chinese characters then have to translate later. Would prefer to restrict on the form itself.…
-
Automatically Track Inventory Usage
I'm new to smartsheets and am not an excel expert, but I've been building some sheets and workflows and have a question about more advanced capabilities of the program. I'm hoping there's a way to automatically track inventory usage based on information input into a separate smartsheet form? I have two sheets: one is the…
-
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…
