-
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.
-
Intake Requests Without Form
I am trying to see if there is a way to create rows via email without having our employees use a form. We are currently receiving a large amount of requests from our branch personnel to our corporate office. These are specific requests for a specific department. The requests are currently coming into our Jira help-desk via…
-
Form flowing into bottom as child row
Hello I have a parent row on a sheet and I would like new entries that flow into that sheet through a form to be automatically indented so it's a part as a child row to the parent row from the beginning. Also, there is a formula that isn't being pulled down to the new row right away. How do I get the formula to fill in?…
