Forum Discussion
Daniel Schmidt
Sep 13, 2018Brass Contributor
Cannot update Hub Site Navigation
Anyone else having issues today updating Hub Site navigation? Tried Different Browsers, Users, Computer, existing and New Hub site... I make the change, hit Save and nothing changes. I opened a tic...
- Mar 28, 2020
Hi Rob Nunley
There many ways to handle this I'll share you my best technique to handle such scenario
Since I have date & Time in my data I will add helper column to handle it effectively.
Helper Column with logical test of TRUE/FALSE
Create helper column check the date/time which each row using the below formula and just filter the values those are TRUE
 
Conditional Formatting
1. Create a custom rule with formula
2. filter the highlighted cell
=AND(A2>=$E$2,A2<=$E$3)
Advance Filters
Use the same formula in cell and follow the steps as below
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official Answer.
Ian-Strickland
Sep 13, 2018Copper Contributor
Same problem here. Hopefully they sort this soon.