-
Volunteer Allocation
Hi All, I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific locations (we do not know these specific locations until last minute). I have built a survey…
-
SUMIFS function
Dear Community, I am desperately trying to make a SUMIFS function work. I have to columns with dates, Start date (startdato) and end date (slutdato). I need to count the days in the period between start date and end date, and add them, where the following criterias are met: It must say "Ida Skou Andersen" in the column…
-
Selection of form in automated update request
I want to use differnt forms to request task updates, depending on my defined user group. E.g. an external user shall only see basic infomation and update a few fields, internal user shall see all information and update all fields. How can I restrict fields in a form, by user group? How can I select a specific form,…
-
Branching Logic in Forms
I need to be able use 11 fields in the logic function of the Forms document. Is there a way to perform this?
-
Display a calculated, non-editable value on a form based on form values
Is there capability to display a calculated, non-editable value in a form? The previous fields are inputs to a conditional formula and I would like to display the results within the form if possible but I can't seem to find a way to do that. Thanks, in advance! Mark
-
Form from one sheet populates another sheet
Hello SS gurus, I am relatively new to SS "in the field", although I've watched over 20 hours of videos from the SS Learning Center so I have a good understanding of the mechanics. Here is what I'm trying to do... We need to track inventory in our supply room: items on hand, items removed, items added, etc. We would prefer…
-
Is there a way to make sure someone can only fill out a form once?
I need to send out a form to staff so they can sign up for an event. Is there a way to create the sheet or form so they can only fill out the form once? Thanks, Karen
-
Forms from Mobile App
Hello, I'm working on an inventory spreadsheet and I'd like to be able to have my team fill out "order request forms" on their phones. I can't seem to locate this as an option on the iphone version i'm using. Is this feature available? Thank you! Erika
-
Enable Form text entry when Dropdown List is not restricted
When a column is a Dropdown List, one can choose whether or not to "Restrict to dropdown values only," however, when a Dropdown List column is used in a Form, only the dropdown values can be selected. Please update the Form functionality to allow free text entry if a dropdown value is not selected.
-
Higher than usual traffic
Greetings. Receiving this error message "We are experiencing higher than usual traffic. Please try submitting this form again. If the problem continues we recommend submitting again later, or contacting the owner of this form for assistance.' for this form: <<Link removed by Moderator>> How can we resolve this?