Ref Rows to Enum List

AppSheet AppSheet Q&A
1

Hi,

I have a low level of skills with expressions and I am having difficulty using ref_rows with an ENUM list, hoping someone can help.

I have a table of staff, where the key is their email address and a table of tasks with a uniqueID() as the key. In the tasks table, tasks are assigned to staff members (an Enumlist, it is set to an Enumlist as some tasks are assigned to more than one staff member. I would then like to be able to generate a table of their own tasks that I can email as a report to each member of staff.

Any advice would be appreciated

Thanks

Andrew

2

Depending on your data structure, there may be better techniques than the following, but here’s a basic pattern.

SELECT(Tasks[Task ID], IN([_THISROW].[Staff Member Email], [Assigned Staff Emails]))
2 Likes
3

Perfect, thanks very much @dbaum !

1 Like