Read Only for submit once approved




I have 2 line item, Submit and Approved, Both are Boolean format.

Once an Item is both checked for Submit and Approved as True, I need Submit(line Item) to be read only, i.e it should not be allowed to unchecked again.


Thanks & Regards,


Best Answer

  • harish_bk
    Answer ✓
    Use two line items

    Submit and Approve
    Third line item should be opposite of approve (Reverse Approve)
    Reverse Approve formula to be "NOT Approve"
    Both Boolean formatted
    Use the dynamic cell acess for Submit and link it with Reverse Approve in the write access driver and Approve in the read access driver