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.
Create a stuff table with email address and role (and other fields if needed). Then you can read the role for your Show_If like LOOKUP(USEREMAIL(),Stuff,Email,Role)=โTruck Driverโ
Thanks, Aleksi. This is what Iโm wanting but it doesnโt seem to be working. For example, I have a formula: =IF(Lookup([Name],Staff,Name,Role)=โTruck Driverโ,โHow many activity codes carted to/worked on today?โ,โNumber of job types worked on todayโ) I have also made a table called Staff and added it to the tables in the app with columns โNameโ and โRoleโ (see below)
However, it doesnโt seem to acknowledge the names Iโve put down as truck drivers. Any idea why?
Instead of using [Name], you should use [_THISROW].[Name]
User | Count |
---|---|
44 | |
29 | |
22 | |
20 | |
14 |