ContributionsMost RecentMost LikesSolutionsRe: Building Nested FormulasI removed the true and I am still receiving the same error message. ------------------------------ Jennifer Hall ------------------------------ Re: Building Nested FormulasThe formula Field is Formula Text. ------------------------------ Jennifer Hall ------------------------------ Re: Building Nested FormulasThis is how I currently have my formulas set up. However, I am receiving the error "Expecting boolean but found text" on the highlighted portion. //Exclude from Report If([Installation Stage]="Refused", "N/A", [Installation Stage]="Remove from Scope", "N/A", [Installation Stage]="Cancelled", "N/A", [Installation Stage]="Pending", "N/A", [Installation Stage]="3rd Party Pending", "N/A", //Errors If([Installation Stage]="Planned" or [Installation Stage]="Installed" and [Target Installation Date]=null, "Error - No Target Date", //On Time v. Past Due If([Installation Stage]="Planned" and Today()<=[Target Installation Date], "On Time", If([Installation Stage]="Planned" and Today()>([Target Installation Date]+Days(3))=true, "Past Due"), If([Installation Stage]="Installed" and [Actual Installation Date]<=[Target Installation Date], "On Time", If([Installation Stage]="Installed" and [Actual Installation Date]>([Target Installation Date]+Days(3)), "Past Due") ) ) ) ) ) ------------------------------ Jennifer Hall ------------------------------ Building Nested FormulasI am trying to assign a category ("On Time", "Past Due", "Exclude", and "Error") based on specific criteria (Installation Stage and dates). After which, I will create a pie chart showing the number of On Time Installations v. Past Due Installations. Exclude Return "Exclude" if the Installation stage equals "Refused", "Cancelled", "Remove from Scope", "Pending", and "3rd Party Pending" Errors Return "Error - No Target Date" if the Installation Stage equals "Installed" or "Planned" and the Target Date is blank On Time v. Past Due If Installation Stage equals Planned Return "On Time" if Today() is less than or equal to than Target Date Return "Past Due" if Today() is greater than (Target Date + 3 days) If Installation Stage equals Installed Return "On Time" if Actual Install Date is less than or equal to Target Date Return "Past Due" if Actual Install date is greater than Target Date + 3 days) ------------------------------ Jennifer Hall ------------------------------ Re: Drop down filter vs user input filterIt looks like there are 457 Division IDs. ------------------------------ Jennifer Hall ------------------------------ Re: Drop down filter vs user input filterThere are over 171,000 records so I am not sure how many possible choices there are for the Division ID and yes the field properties are set to searchable. ------------------------------ Jennifer Hall ------------------------------ Re: Drop down filter vs user input filterBoth fields are text fields with the same settings. ------------------------------ Jennifer Hall ------------------------------ Drop down filter vs user input filter The filter for the District Name column is a drop down that the user can choose a selection from whereas the Division ID column the user types in what they are searching for. How would I go about changing the Division ID column to a drop down? ------------------------------ Jennifer Hall ------------------------------