Hello,
Iโm wondering, is there a function in AppSheet similar to COUNTUNIQUE from Google Sheets? Or perhaps just UNIQUE?
Iโm still new to expressions, but hereโs what Iโm trying to write: IF(COUNTUNIQUE(SELECT(Employees[Garment Type], [Company]=[_THISROW].[Company]))>2, โresult if trueโ, โresult if not trueโ)
Thanks
Yes, the optional third input to SELECT() tells it whether or not to eliminate duplicates.
Perfect, thanks!
Hi @Jenn_M I request you to evaluate following
IF(COUNT(SELECT(Employees[Garment Type], [Company]=[_THISROW].[Company], TRUE))>2, โresult if trueโ, โresult if not trueโ)
Please note that in the above expression, the select statement itself selects unique (duplicates free) values in the list. Count merely counts those unique values in the list. I believe the end result is same.
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |