Don't want to show the DataMesh Lookup Value
Is there a way to use the DataMesh Lookup Value (in this case an employee ID #) to match rows but not actually INCLUDE the Lookup Value on the target sheet (or at lease make it not viewable)? I want to share information on the target sheet with groups of people that are not in our department without sharing the employee ID but the employee ID is really the best unique identifier. I can just hide the column of course but there is always the chance that someone with admin permissions would leave it unhidden.
This is actually a work around for what I REALLY want to do which is to put this in Dynamic View but the reason I can't is because there are checkboxes (for attendance to an event) that you can't simply quick click 30 people without clicking into each line item to check them off and then saving. So tedious.
So, I am back to the question above! Any input or advice would be fantastic.
Help Article Resources
Check out the Formula Handbook template!