Sign in to join the conversation:
Hello,
I am trying to set conditional formatting to highlight due date cells when it is within 3 working days, however the sheet counts Saturday and Sunday as days.
Is there anyway of setting the sheet so saturday & sunday do not count as days?
You may need to use a WORKDAY or NETWORKDAYS formula somewhere. You could put it in a hidden column or use it to drive a RYG column and base your conditional formatting off of that.
Thanks very much. I will look at this on Monday, have a great weekend.
Thanks again
Hi everyone, in several of my Details Views for multiple Dynamic Views, text fields and/or checkboxes that are configured in the Dynamic View settings are not appearing in the Detailed View. Is anyone else seeing this today? I've not updated any of my configurations lately and don't know how to explain this! Thanks!
The timeline widget has a toggle: Set the default hierarchy state. I am turning on "expand lanes by default." It seems regardless if I turn this "on", save, sign out, and sign back in, it automatically changes back to "off" when I log out. I have tried clearing my browser cache.
Can someone tell me how to get rid of the 120.0% max on this graph? It is always going total 100% and never any more, so I would like to use more of the space for graph display purposes. I even tried reducing it so that the largest value was 99.999%, thinking maybe being exactly 100 would cause the next "level" to…
