Parent / Child - Formula
We're stuck on a formula and not sure if it is remotely possible in the first place.
Can a Boolean be TRUE for the Parent but FALSE for all the children?
To give some background:
In a Planning model on Dynamic Time (lists, not native time) we have Week - Day hierarchy.
On the dashboard there's a 52 Weeks input Boolean to select which weeks you want to see in Days.
When the Week is selected, a Boolean on the Day format looks up the value of the Parent and will then be TRUE for all the children. Showing all the days in the selected weeks.
The requirement has changed however that they want this functionality, but for the Weeks that are not selected the Week should still be shown but not in Days, thus the parent.
Hope this is explained well enough.
Thanks to the brave for taking a jab at this!