Hello community,
I am aware that by adding REF_ROWS I can take out the projects lists that staff is involved with. But my query here is, I have a project which is handled by multiple staff. So basically the โStaffโ column in the โProjectsโ data table is ENUMLIST.
Now when I am in โStaff Detailsโ, I need the โProjects Involvedโ list below him/her. The error I am getting when I use REF_Rows is, cannot compare the text with a list. Because the โStaffโ column in the โStaffโ table is text type and is a key as well.
Can any senior solve this?
Solved! Go to Solution.
Instead of REF_ROWS()
, try this:
FILTER(
"Projects",
IN([_THISROW], [Staff])
)
This assumes the Staff
column of the Projects
table is an EnumList
of Ref
to Staff
.
Instead of REF_ROWS()
, try this:
FILTER(
"Projects",
IN([_THISROW], [Staff])
)
This assumes the Staff
column of the Projects
table is an EnumList
of Ref
to Staff
.
Smoothโฆ
That solved my issue.
Thanks, Steve.
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |