Hide or make worksheet column field greyed out based on condition
Summary:
I need to hide or make worksheet field greyed out based on condition.
The worksheet has a component which is for exceptional performer employees.
Amount : Compensation amount -component 1 column is holding this value which is user enterable.
Justification: Also, a text column is defined in user defined columns for capturing justification for the above compensation amount - component 1 column.
For terminated employees compensation worksheet displays terminated employee row. The Compensation amount -component 1 column is greyed out and justification column is user enterable.
I tried role based overrides for Justification column by override setting - read only and assigning roles in the list.