I would like to make a scheduled report for if a employee has not created a daily time card record within 5 minutes of arrival. For the โif this is trueโฆโ portion would I use a ISBLANK(SELECT()) expression to see if a specific type of row is missing?
Yep!
Ok so I have been using this report for a while and I like the feature. I used this โIf Trueโ expression:
ISBLANK(FILTER(Job Board, AND([Account Name].[Account Name] = โSign In Sheetโ, [Date] = TODAY(),[Crew Leader].[First Name] = โJoshโ)))
I am having a hard time figuring out how to scale this up to iterate through the [Crew Leader] table to see if each crew leader has created a โSign in Sheetโ and if not send that crew leader a text to remind him to sign in.
User | Count |
---|---|
32 | |
31 | |
30 | |
18 | |
17 |