Dependent line items



I have a Headcount line item and an end date line item in a classic, user input dashboard.  I want to prevent users from entering a zero in the HC line item unless they also input an end date.  In other words, I should not have a 0 in headcount with a blank end date.  I already have conditional formatting but wanted something more preventative.  Is this possible?



  • @ckelleher 


    I don't believe this can be done as you have stated...Now, if you have a "finalized" boolean that is checked for validity, then you can put DCA (Dynamic Cell Access) on that so it is read only or hidden until the user fills in the data appropriately.  



  • I'll explore the DCA option which might work.  Thanks!