I have a timesheet app which various staff use to log hours, plant and materials.
Different kinds of staff will see different columns or column descriptions to make it clearer to use.
I want all truck drivers to see something different to laborers. To achieve this I currently alter individual columns’ ‘show if’ formulas and list all the names of truck drivers.
Instead, I want to have a reference list of ‘Truck Drivers’ in a spreadsheet and have appropriate columns’ formulas reference that list, so I only have to type a new employee’s name in one place as opposed to going through every single formula.
Can someone teach me how to do this, if it’s possible?
Thanks in advance.