I have a table that’s a list of tasks for clients. Grouped by client. How come that I got two groups for the same client? [image] And no, those aren’t two different rows — it’s the same client. Hint: some tasks were entered manually with client being selected from a drop-down list. And the other…

Not sure if this is what you’re getting at, but it seems similar, anyway: Manually entered tasks with client selected from drop-down list = single row. “Current client” field returns a list of some kind (e.g., Filter(), Lookup(), etc). Tasks created by button copy the list-of-one value to the clie…

Here’s a riddle for the community

Denis_Peshekhonov July 15, 2019, 4:31pm 9

Cool. Thats why we need FilterFirst() function

Topic		Replies	Views
A mess with sorting a connected date column	2	1532	August 25, 2019
The weird examples corner Puzzles	11	1625	May 9, 2018
Table filters behaving strange	7	574	December 12, 2022
Lookups, different results, different input methods?	21	2778	September 26, 2021
Subtract from a List	9	240	October 26, 2023

Here’s a riddle for the community

Related topics