Options where more than one 'Modified By' column is required
I have a sheet where I need to capture the name of the person who 'checks a box'.
I have used the 'Modified By' system column to do this.
Unfortunately, I have 3 check boxes in total.
Any ideas on a workaround, other than a copy row to two sheets with an INDEX MATCH pulling in the name on the 'master' sheet? Or a manual dropdown for the User to enter their details?
Many thanks in advance!
Help Article Resources
Check out the Formula Handbook template!