Google Developer forums
Return mail adress on two conditon (search in enumlist)
AppSheet
AppSheet Q&A
expressions
TeeSee1
September 20, 2022, 1:55am
2
Try
SELECT( STAFF[E-MAIL], AND( [POST] = "PROJECT MANAGER", IN( [_THISROW].[SITE], [PROJECTS] ) ) )
3 Likes
show post in topic
AI Suggested topics
Topic
Replies
Views
Activity
List Emails to send
AppSheet Q&A
intelligence
,
expressions
11
5
June 21, 2022
Automation sending email some people role from another table
AppSheet Q&A
automation
,
expressions
1
1
January 20, 2023
Create a list of email addresses from the values in EnumList
AppSheet Q&A
ux
,
expressions
4
7
October 26, 2022