For more information, please refer to this announcement explaining best practices for getting answers to questions.
Worksheet values changing on their own
Content
p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica} p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; min-height: 14.0px}
Hi everyone,
On our compensation worksheet we give managers the option to enter salary increases as either a percentage or an amount. Both the Percent and Amount columns are editable and calculate off of each other using dynamic column calculations. For example, if an employee’s current salary is $100,000 and the manager enters 5% for the salary increase Percent than the salary increase Amount column populates with $5,000. Alternatively, if they entered the $5,000 increase in the Amount column it would trigger the dynamic column calculation for the Percent column and populate it with 5%.