I have a timecard app where supervisors can go in to approve or reject employee timecards. We have 2 actions set up to accomplish this - approve/reject - and they work as expected. The only issue is that the [Employee Name] column is changing from the employee name who originally completed the timecard to the supervisor name approving/rejecting the timecard.
I tried using “Editable IF” in the [Employee Name] column to restrict changes but the [Employee Name] column has an app formula which looks at a ref column - [Employee Email] - to pull in the employee name, so Editable IF won’t work.
I’m stumped… Any suggestions?