Hi community
I need some help with expression logic.
I have an enum column with 3 options. Sunny, Hat, and Wonder.
I have an initial value expression
IFS(USEREMAIL()=sunnytab@gmail.com,"Sunny",USEREMAIL()=hattab@gmail.com,"Hat",USEREMAIL()=wondertab@gmail.com,"Wonder")
This allows the users at these three locations to not have to select their location.
However, I have an area manager who wants to be able to capture data on behalf of any one of the stores but I'm lost on how to give him access to be able to choose any option as it does not show the question in the form with the above expression.
Can someone help me with advice, please?
User | Count |
---|---|
36 | |
9 | |
3 | |
3 | |
2 |