ANY& SELECT& LEFT

AppSheet AppSheet Q&A
1

Hello,

I have 2 tbls :PAYROLL and LABOR.

I need to take only the 12 characters from each recordin the LABOR table .

The formula how it is it give me only the very firs record that mach the conditions

LEFT(
ANY(
SELECT( LABOR [EMPLOYEE],
And([EMPLOYEE] = [EMPLOYEE],
CONTAINS([EMPLOYEE], [EMPLOYEE])))),12)

I put also [_THISROW] in both the AND conditions but isn’t give me give me any result.

Thanks in advance

Do you have any tips?

2

You’d need to add a new column to LABOR that pulls the first 12 chars from each employee, then select on that new column.