The code that you have below is what I need but I don’t need a parameter to pop up. When I put in that code or my code, and hit run I’m prompted to enter a parameter. I need it to pull info from the academic column and waiver column if both are yes then have approved appear and if not yes then not approved. I have a new column Status that I’m trying to zoom on the title and enter that information in. Now I’m getting invalid syntax.
This is the code that I have created: Now I’m getting invalid syntax
Status: IIF([Waiver]=”Yes”, and IIF([Academic]=”Yes”, “Approved”, “Not Approved”)