Not sure how to title this, but here is what we are trying to do: We have a ref column to our Employee list. When an employee leaves, they are no longer in the ref column, but they are in the Sheet that is being used to create the records (ie AllEmps is a read-only table where we are pulling employee data from, Terminations is a table where we are storing the data in the App). When the employee is removed from the AllEmps table, the App shows the yellow triangle with exclamation point on any record where the employee has been removed from AllEmps.
We are thinking that we want to make an if statement on the ref, that if the record status is complete, look to the Terminations Sheet not the AllEmps.
Thanks in advance…hope it makes sense.