-
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!
-
Pulling in data from external source
I work with large data sets on parts (60,000 SKUs) and I have a form and workflow for processing special pricing requests from our field. I'm curious if I can house the prices on an external excel file or sharepoint and pull in the pricing for an individual part. Since Smartsheet limits the row count to 5,000 I can't just…
-
Form
I created a form some months ago and I need to expand it now by some columns, but the update just doesn't show for the user who is filling in the form. Can anybody help? Thanks!
-
Indent from a form
Is there a way to have a row come in automatically at the same indent level as the row above it? My top row is a parent row with calculations based on all of its children. The children rows are all web form generated and they do not come in indented so I have to manually indent each row as it hits the sheet.
