-
Help with collect formula with multiple AND arguments
Hi folks, I am currently using this formula, which works fine: =IFERROR((AVG(COLLECT({#Working Days to Kickoff with KP}, {Verizon Received Date}, AND(@cell <= DATE(2023, 1, 31), @cell >= DATE(2023, 1, 1))))), "") This gives me the average time we take to kick off our projects from the date we receive our projects from the…
-
Logic in Forms RE: Max/Min Date Conditions
I am trying to build a form that is for tuition reimbursement applications. By policy- applications cannot be received either 30 days before OR after the semester start date. I have a pop up message built into the logic to appear if one of those conditions are met. However, I can get only ONE to work, but not both built…
-
Improve how logic functions work with contact columns
If a contact (e.g. one in my personal contact lists) has a text field name associated with it, it displays as that name. Then, if wanting to search for that contact in a contact column using the associated email address, it is not found. Please develop a function that returns as text the email address of a contact.…
-
Merged: Mandatory Fields & Logic in Update Requests
This discussion has been merged.
-
Conditional Logic on Likert Scale Not Working
Hi Community, I've created a form with conditional logic. All of my logic works perfectly except for a 'any of' Likert Scale response. For context, if a user submits a response of 1, 2 or 7, a secondary question should populate. The response list does include'N/A', i.e. N/A, 1, 2, 3, 4, 5, 6, 7. I have already attempted to…
-
If a checkbox is clicked on a form, can a field populate from previous data?
Hello, I have a form where the user would enter a Contact 1 name and Contact 1 email. Then a bit later there are fields for Person A name and Person A email. Often Contact 1 and Person A would be the same information (but not always). Currently in an Acrobat form, there's an option for "Person A (check box if same as…
-
Creating a Form with Multiple Languages
I have an intake sheet that will have information being gathered globally. I would like to have a language choice (currently 8 are available with our current system) at the beginning of the form and depending on the response, the corresponding translated questions would appear. I just don't know how to do this with the…
