I have a timesheet app which various staff us...

[Nathan_McGregor]

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.