I have a data table that I am trying to display a list of records that are missing a date along with 2 other criteria. I can get the data to show with the two of the criteria but can not get it to include the missing date criteria.
Got this to work with only 2 of the 3 criteria:
Filter('PROJECT DATA', ProjUserEmail=User().Email && ProjStatus="Pending Construction")
I have tried the following with no success:
Filter('PROJECT DATA', ProjUserEmail=User().Email && ProjStatus="Pending Construction" && USERUPDATE="")
Filter('PROJECT DATA', ProjUserEmail=User().Email && ProjStatus="Pending Construction" && IsBlank(USERUPDATE))
The data table should include.
Source=PROJECT DATA
Field Criteria = ProjUserEmail should equal the users email
Field Criteria = ProjStatus should equal all that have "Pending Construction" as a value
Field Criteria = should only include all dates not entered or blank in field USERUPDATE
Looking for some help. Thanks