Hi there, I have a question regarding the user email, I have an app that allows the user to do inspections based on yes and no questions in the app. You need to select who is doing the inspection, I want to know if it is possible for the app to auto select the person doing the report based on the user email and โInspector emailโ I have in my sheet. The โInspectorโ field inside my โInspectionโ sheet does not contain the email, this is in another sheet named โInspectorsโ where one of the columns is named โEmailโ.
Is this possible to do?
I have tried modifying this script but with no success: =OR(IN([UserEmail], {โAdminEmail1โ, โAdminEmail2โ, โAdminEmail3โ}), [Market]=ANY(SELECT(Techs[Market],[UserEmail]=USEREMAIL())))
User | Count |
---|---|
32 | |
31 | |
30 | |
18 | |
17 |