I am trying to build a timesheet app. I have a tasklist sheet with a list of projects and subprojects. There are a total of 14 rows on the tasklist sheet.
Each team member needs to be approved to work on tasks. Team names are listed in columns in the same sheet. So imagine an array of tasks in rows and team names in columns. An ‘X’ is placed in that cell if that team member has approval to work on that task.
I now want to have a choice component that only offers the tasks that a team member has approval to work on. Can I accomplish this by utilizing the user specific column feature?
Thankyou for all your help.