I’m using a Valid if statement to bring a dropdown list of names into a report: SORT(Graffiti Contacts[Name]). The list automatically gets undated from another system. This works fine. When the reported issue has been fixed, the report is edited to indicate the work is complete. But if the person who made the initial report has left the Graffiti team, the edited report returns “This Entry is Invalid” because it cannot find their name.
I tried to fix this by adding a Required if statement: ISBLANK ([_THISROW].[Work Status]). For a new report the Work Status will be blank so the Name entry is required. For an existing report the Work Status always already exists so the Name entry should not be required. I hoped this would clear the error “This Entry is Invalid” but it has not.
Any suggestions would be appreciated.