-
How to check if cell contains one thing or another?
Hi all, I'm making a sheet that references another sheet to get data for a detailed graph. I'm trying to count the total number of small, medium, and large projects. The formula I have that works for individual campuses is as follows: =COUNTIFS({Size}, CONTAINS("Small", @cell), {Campus}, CONTAINS("Example", @cell), {In…
-
Not counting based on multiple factors
I'm building a formula that uses the contents in a cell to effect a percentage. Basically: =(count all cells within a range with the word "PASS") (divide this number by) (All the cells within same range that are NOT blank ) The piece of the formula that looks at the row and avoids blank cells looks like this:…
-
Apply logic to document upload in Form
I would like a feature where the "logic" pathways can be applied to the Document Upload field in a form. For example, when you upload a document, the logic allows additional questions/texts to become visible. Essentially certain aspects of a Form would only become visible after a document is uploaded.
-
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…