-
Getting information from the latest line entry based on date
Hi, I'm setting up a page where you enter 5S audit test data from a Form. It puts a new row in every time with the 5 different 5S scores each in it's own column. We need to find a way to pull the data from the most recent new row. I need a way of identifying the row with the most recent date and then moving across X many…
-
Select a user defined value for a default in a form
Hi, I have an inventory sheet where users are putting products in a box, the user would like to minimize the number of clicks as they are moving large number of products a day but these products will go into several boxes. is there a way to have a form look at a value the user maintained in a table, (box number), then have…
-
Putting a formula in with a form submission.
We are trying to set up a form where you enter scores base on criteria that populates a form. Based on that data each new line of data from the form needs to have the average score of those 6 criterias. However we can't pre-fill each row with the Average formula we want as the form always drops the data in the row below…
-
INDEX MATCH to OTHER WORKSHEET
Hello, I'm evaluating the use of Forms for a "field ordering" system from an Item Master Table. Best scenario is to create a form to request multiple items via a single submission (not multiple items in a single cell = less desirable data management), and also to have a confirmation submission email sent to an email…
-
Editing Drop Down Lists
Hi, I have created a drop down list of names but i accidently found out that i missed one. How can i add a new name to the already created drop down list? Thanks in advance
-
Rostering for Global Customer Support
Hi, I have been asked to create a roster that covers customer support across different time zones and shows who is available (human resources), who is on leave, time, names of the support person and who is on call. Also, includes our contractual obligations with customers in an easy display view to the eye. Do you think…
-
Autosuggest contact names in form
Hi, can anyone help? We have created a booking form to request tickets for an event on a certain date. As part of the booking process, the user can also select up to 17 other (internal) guests to accompany them to the event. I have already configured the following * set the guest column up as contact type * allowed…
-
Work Orders
Been using Smartsheets for over a year with just some basic tracking sheets and task lists to share. Ready to make the jump into more complex sheets. I have 18 warehouse facilities across the country and trying to come up with a sheet to track the numerous work orders that come through my office. Was thinking of creating a…
-
Populate Sheet Summary with Form?
Hi there, I'm learning Smartsheet, so apologies in advance for the basic question. Is it possible to populate the Sheet Summary via a Form? If so, how? We have a sheet we want to create with minimal structural information in place, and the Form should be used to supply metadata we use to track and manage the sheets…
-
Added information needed on Approval workflow
I have many forms - which are requests that need approval. When I create the approval workflow, it sends 2 buttons - Approve or Decline. I need more. I need a NOTES section for when it is denied so that the reason can be recorded on my sheet. I also need the name and date of the approval added to my sheet. The only thing I…