Hi all,
I have 5 slices for 5 weekdays (Mon, Tue, Wed, Thur, Fri) and I would like a button to trigger a slicer based on the day of the week.
Open to any suggestions as well.
I have an employee list with 5 columns (Mon, Tue, Wed, Thur, Fri) that either have "yes" or "no" value and just need a button to show who's not in on the current day the spreadsheet is open.
I can add simple formulas like "=TEXT(TODAY(),"ddd")" to return the current day but just not sure how to connect to a macro to fire off a slicer relating to the current day.
The button in green below says "Who's Here Today?" but would just to Who's Not Here Today, as you can see, for Thursday it would show that one entry as it has "No".
I have 5 slices for 5 weekdays (Mon, Tue, Wed, Thur, Fri) and I would like a button to trigger a slicer based on the day of the week.
Open to any suggestions as well.
I have an employee list with 5 columns (Mon, Tue, Wed, Thur, Fri) that either have "yes" or "no" value and just need a button to show who's not in on the current day the spreadsheet is open.
I can add simple formulas like "=TEXT(TODAY(),"ddd")" to return the current day but just not sure how to connect to a macro to fire off a slicer relating to the current day.
The button in green below says "Who's Here Today?" but would just to Who's Not Here Today, as you can see, for Thursday it would show that one entry as it has "No".