-
Create a Form with Auto Filled
I have a sheet (Sheet 1) that is my Master Project. Each project has to create subtask request for another department (within Sheet2) but a lot of information prefilled in Sheet 1 needs to be fulfilled into Sheet 2 when the request is made to that other department. Is there a way to create a form within Sheet 2, use the…
-
Auto-populating sub-tasks from Form.
Hello. I have a list of tasks, assigned to different people, that have to happen each time a new topic comes up. Ideally, when a user submits those topics via a Form, I would like that list of tasks/assignees to auto-populate as sub-tasks below row of information that was submitted from the form. Is that a thing that can…
-
Can I make a form demand EITHER field be required?
Hullo: I am using a form to track outside vendor shipments. Sometimes our shipping team gets stuff into the system in advance, sometimes after it's been picked up. I would like a form that requires either Estimated Ship or Actual Ship. If one is filled, the other doesn't need to be, but at least *one* of them must be…
-
How can use a field several times within a form?
Hi. I need to collect feedback about several programs using a form. The form should include the same questions for each program. Any ideas about workarounds that allow me to use a field several times within a form? I want users to receive one form to collect their feedback about the different programs.
-
Approval Chain
Hi, I am trying to set up a work flow with the approval chain below: Someone submits a form, it gets sent to a Manager for approval. If approved, the employee gets an email stating such. If it is denied, the manager can add notes on what to fix, it gets sent to the employee to fix. I have that workflow set up. However, I…
-
Can i configure a workflow to alert someone when a specific entry is put in on a multi-select column
I have a form we are using to collect information on team activities. One of the form fields is a multi-select column where entrants can select all of the partner teams they will need to conduct the work outlined on the form. I'd like to send an alert to a "point of contact" for each team that is selected as a partner. The…
-
Viewing Submitted Forms
Good morning, I'm creating a form that I'd like to be able to save the responses as a PDF document. As far as I can tell, the only way to see submitted forms is through the sheet itself - not in any "document" format that could be easily saved to a DMS. Is there a method to show submitted form data in a way that would…
-
Recent Submission Formula
Hello, My goal is to create a formula that will automatically update the current status of our utility systems based on the submission of the most recent inspection form. Basically, I'm looking to create a green dot on a separate sheet if ARU1 and ARU2 are both online and both temperatures are in spec (I can provide the…
-
Strange Formula Behavior
Greetings, I am developing a solution that automatically captures a 24-hour time (as an integer value) from the generated system date/time. The goal is to allow users to use a form on a tablet to enter a few fields of information into three sheets. My solution converts the times in each sheet correctly: Above is a portion…
-
How to use index/match on multiselect dropdown list?
I am working on launching a global hiring form that uses this formula: =IFERROR(IF(Country@row = INDEX({Approved Seats Country}, MATCH([Unique Seat Code]@row, {Approved Seats Unique Seat Code}, 0)), 0, 1), 2) Basically this formula returns the number "1" by searching for the name of the country in the source sheet…
