Hello guys,
i need your help
I'm trying to collect data for a list of specific value in the [sub activity] column with value in the [activity] column. i use this formula select(reference[sub activity],([activity]=[activity],true)) in suggested values, but it doesn't to work. Thank you very much for your help
Solved! Go to Solution.
Hey @TeeSee1 and @MultiTech i think i solved my problem with this formula SELECT(reference[activity], NOT(IN([activity], SELECT(activity[activity],[request_number]=[_THISROW].[request_number], TRUE))))
I group activities by request number, so i added new column [request_number] in activity table.
every activity that I have entered with the same request number will no longer be shown in the list.
select(
reference[sub activity],
[activity]= [_THISROW].[activity]
)
I didn't realize it to just need a little adjustment. Thank you TeeSee1-san
is it possible for the user to enter only once for each column based on the query number? I mean no duplicate data. I will add the query number column later
Instead of using Select() to brute force your list of [related sub activities]
I'd check out references. ๐
Hey @TeeSee1 and @MultiTech i think i solved my problem with this formula SELECT(reference[activity], NOT(IN([activity], SELECT(activity[activity],[request_number]=[_THISROW].[request_number], TRUE))))
I group activities by request number, so i added new column [request_number] in activity table.
every activity that I have entered with the same request number will no longer be shown in the list.
User | Count |
---|---|
25 | |
25 | |
24 | |
21 | |
20 |