Is there a way to show employees who can cover a shift based on meeting the credentials?

jarcher

I have employees who submit a request if they need time off. We have all of their credentials listed in a separate sheet (ex: employees have licenses in certain states). Is there some sort of tool or resource or formula that when someone submits time off request, we can easily see the people who can cover rather than going through the full list one by one? We utilize the Calendar App as well. Any ideas if this is even feasible would be much appreciated!

Andrée Starå

https://community.smartsheet.com/discussion/128462/is-there-a-way-to-show-employees-who-can-cover-a-shift-based-on-meeting-the-credentials

Hi,

I hope you're well and safe!

You could use cross-sheet formulas combined with a VLOOKUP, INDEX/MATCH, or INDEX/COLLECT structure to collect the data and show others with the same credentials.

Make sense?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!