-
auto incremental's from form data
I am trying to make a column auto fill down based on the number in a column. So if column [# of Registers] shows 5. i would like the Register Hostname to populate out from USRETAMXT01 - Reg05 down the column.
-
Forms - SmartSheet Form not the same as Form received by Action Parties to enter data
I have a Smartsheet that tracks Action Items. I created a Form that shows Action Parties data from Smartsheet and requires them to enter responses. The Form sent to Action Parties that appears in Emails and can be opened from the Email to enter responses does not contain the same cells as the Form in SmartSheet. Why? See…
-
Ability to create a form that will reference rows instead of columns
I have an existing extensive sheet that is built upon rows, i can only seem to create forms based on column headers, is there a way to do this for rows?
-
Can I use a form to complete a partially-completed row?
I know forms are used to add data to a sheet, but can a form be used to complete/edit a row that is already filled in?
-
Smartsheet Form Fields (HTML)
While I like that Smartsheet has forms to collect information from users, they are very limited in how data is collected, as well as limited in visual design options. With Google forms, I can create a form, view it in a Web browser, and then identify the actual form fields in the HTML and use those same field codes in my…
-
Forms and Formulas - Form add a row to top but formula does not include
I have a smartsheet that I want to use for team holiday requests.The team would fill in a form that add their request to the top of the smartsheet. Further down the smartsheet is a summary, by team member, of their total holiday allowance, calculated by formula of the number of days requested (and approved) and number of…
-
Legal projects/task management sheet
Hi, I’m part of an in-house legal department. The company has different departments and different types of contracts/advice they require us to produce. To track the work, I have created one sheet for the legal team to use, covering all main "legal work" categories and then broken down to sub categories, tasks and then sub…
-
One SmartSheet - Five Separate Forms - Possible Overwritten? How can I retrieve old forms data?
Hi there, Is there a way to retrieve old form data and have the output into a new smartsheet? The information may have been deleted or overwritten with each new iteration of the form as the new information was not added or archived. But the forms are still there with the amount of responses. Please help!
-
Best Practices Help - Form initiated workflow with 3 regional spin-off sheets
New user looking for some advice. We need to: Capture requests from a form(s) and save the original data. We know comments and attachments will be made by other users, and we don't want them to mess up what was originally there, or the original data in other rows put in by other users. We will have 3 regions that will…
-
Limit Form Entries to 1per Person
Is there a way to limit form entries to one per person? Can the link to the form be limited to single use? Thanks in advance!