Hello Gliders,
I have a timesheet app where users enter their hours. The hourly wage rate is based on titles (Operations Level 1, Operations Level 2) and we increase the hourly rate periodically. A users title can change over time based on promotions and movement within the org. I would like Glide to look up the appropriate hourly rate for the employee based on their current title and date worked. I’m open to suggestions on how to set up the google sheet. The way I’m going about it right now (and am getting stuck with the lookup) is as follows:
- I have a sheet titled WAGE RATE which has columns for team members name, title, date title was assigned and wage rate
- I have a sheet titled TIMESHEET where users enter their hours. I would like to have a glide column here that looks up the appropriate wage rate in the WAGE RATE table based on the user’s email and date work was performed
This is where I’m stuck. I can’t seem to figure out if I need a google formula to look up the rate (not my preferred option) or if there’s a way to get Glide to do this for me (preferred option).
Thanks for any help you can provide.