We have a "Job Sheet" view which is a list of jobs that have been assigned to your useremail() using a slice. The slice is AND([Email]=USEREMAIL(),[Status]=Planned). Planned means the job is ongoing.
We also have a "Job Notes" view which is a list of all jobs that all other employees have completed, and left notes for the next person who is assigned this client. The slice we use on this view is ISNOTBLANK([Notes or reminders for next visit and customer requests]).
We want the "Job Notes" view only to show records that have the same client as the ones you have been assigned in the "Job Sheet" view, but can be records created by anyone.
What expression would we use for this slice? I have been on the Appsheet live chat and they couldn't figure it out.
This:
AND(
ISNOTBLANK([Notes or reminders for next visit and customer requests]).
IN([job-id], Job Sheet[job-id])
)
Replace the first job-id with the name of the column in Job Notes that identifies the job. Replace the second job-id with the name of the column in Job Sheets that identfies the job.
User | Count |
---|---|
35 | |
11 | |
3 | |
3 | |
2 |