Notifications
Clear all
Topic starter
Hello!
I've spent far to long on this and I know it's a simple solution, but I have to admit, I need help.
Every time a new row is added and when an item is selected from the drop down list, the next column equals a corresponding percent.
e.g. If I select "N STAT" from drop down, then that = 0%
Data
| Drop Down List | Corresponding Percentage to Equal When List Item is Selected |
| N STAT | 0% |
| 10 CMP | 5% |
| 30 CMP | 20% |
| 50 CMP | 35% |
| 70 CMP | 50% |
| 90 CMP | 60% |
| RT | 50% |
| CQ | 60% |
| V OMP | 80% |
| C ENDO | 90% |
| AQ | 95% |
| SMDOI WRK | 97% |
| CRN / APR | 100% |
| RTRD | N/A |
Spreadsheet Example
| Document | Author | Sub Group | Status (Drop Down List) | Percent |
| Safety Practice | Melissa Smith | Safety | N STAT | 0% |
| Light Bulb Change | Arthur Joy | Action | 90 CMP | 60% |
| Sweep Floor | Jay Jones | Action | C ENDO | 90% |
| Clean Walls | Harry Tan | Action | CRN / APR | 100% |
I thank you in advance for you help, it is greatly appreciated!
Posted : 21/03/2019 10:58 am
Hi Ellen
You can try using Data Validation and VLOOKUP.
See if this help.
Sunny
Posted : 21/03/2019 7:04 pm