Return True if any Cell Value Within a Time Range Meets a Condition
I'm trying to display a submit checkbox (boolean) on the dashboard. However, I only want the checkbox to be available if the cell value for all years have a value greater than 0. The years you see in the image is a Time Range (so, not Model Calendar).
I would appreciate any insights on how to approach this. Thanks.
From the screenshot provided i get that you also have a 'growth cell check' boolean line item, that is true only when there is value in the %growth line item. So you apply a DCA in the 'Submit' line item using the 'Growth cell Check' line item. Basically you need to select this line item i.e. 'Growth cell Check' in the write access driver option in the blueprint of the 'Submit' line item.
This will restrict the access of editing the line item only to the values where the Growth cell Check line item is true.