Forum Discussion
Formula help with true / false maybe?
Hello, I would like to use a formula to help with our work schedule. We need to have am and pm coverage every day for 2 positions. For several weeks one of the shifts keeps getting missed about ...
MorrillL Hopefully you are using Excel 365. Attached is a sample sheet where I used the FILTER() function to create a list of the employee names that are signed up for each location. You could use that table to highlight red if they aren't fully staffed but I think the visual there is probably enough and probably useful in other ways too.