Dependent line items

ckelleher
ckelleher
in User Experience

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?

Tagged:

Answers

  • rob_marshall
    rob_marshall

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

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

Categories