Dependent line items

ckelleher
New Contributor

Dependent line items

Hello

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?

2 REPLIES 2
rob_marshall
Moderator

Re: Dependent line items

@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.  

 

Rob

ckelleher
New Contributor

Re: Dependent line items

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