
Ellen Robinson
New Member
Members

Forum Posts: 1
Member Since:
March 21, 2019
March 21, 2019

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!
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Mynda Treacy, Bryan Barnett, Lorna Henning
Guest(s) 8
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 880
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 237
Jessica Stewart: 219
A.Maurizio: 213
Aye Mu: 201
Hans Hallebeek: 185
Newest Members:
Appiagyei Kofi Frimpong
Hilary Burchfield
Richie Wright
Adel Kock
Barbara Murray
Doug Milne
Siobhan Stringer
Rob Rooth
Tom Lewis
Jennifer Rodriguez-Avila
Forum Stats:
Groups: 3
Forums: 24
Topics: 6542
Posts: 28641
Member Stats:
Guest Posters: 49
Members: 32829
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen
© Simple:Press —
