Hi there, I have a question regarding the use...

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())))

0 1 276
1 REPLY 1

You can read the user with the LOOKUP expressionโ€ฆ LOOKUP(USEREMAIL(),Inspectors,Email,Name)

Top Labels in this Space