Controlling worksheet column access — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Controlling worksheet column access

edited Sep 5, 2020 12:17AM in Compensation 5 comments

Summary

Can we control read-write property of worksheet column based on custom column value?

Content

We use delivered worksheet column for managers to choose rating for their employees and click save. We have only one plan to do ratings and merit increases.

 Ideally we do it in 2 phases. Phase # 1 is for ratings and # 2 for merit increases.

In phase # 1, we ask managers to give rating and if they are interested in starting merit allocations (for phase # 2) they can plan by entering salary increases.

However we don’t enable ‘submit’ and ‘approve’ at plan level in this phase # 1. Because if submit is enabled, then worksheet is read-only and managers can’t plan merit allocations for following phase. 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!