reneev
Board Regular
- Joined
- Apr 26, 2017
- Messages
- 53
I have a rather large HR survey that I have to do quarterly which counts certain positions by Full Time/Part Time/Per Diem status. This survey counts these by: headcount, new hires, voluntary/involuntary terminations. Before I came along, it was all done manually. I eventually turned it into a bunch of pivot tables which have to be updated each quarter for the data source, sometimes I forget to update one and then my numbers are off (usually not found until the following quarter). Basically, all the pivots make the data file a mess and only I can read it.
I have been considering redesigning it to countIF formulas in which I feel like would be cleaner. However there would be a lot of IF values (if column is this position, if column is "bedside" or "non-bedside", if column is Full time, if column is Part time, etc...).
Before I spend an entire day redesigning, can you think of any downside to doing this? I hate to get most of the way through it and find out that it doesn't work because of something I hadn't thought about.
I have been considering redesigning it to countIF formulas in which I feel like would be cleaner. However there would be a lot of IF values (if column is this position, if column is "bedside" or "non-bedside", if column is Full time, if column is Part time, etc...).
Before I spend an entire day redesigning, can you think of any downside to doing this? I hate to get most of the way through it and find out that it doesn't work because of something I hadn't thought about.
