We have a Team Document where I created the Acces Rules similar to the Crowdsource template. A user in the Team is able to see all the records, but he can only create new ones and update or delete is own. Not the ones other created.
Now I was thinking, because the entries get sorted or filtered and with many entries it is sometimes difficult to remember wich entries a user made, and wich ones are not is own, is it posible to highlight (with conditional formatting) the rows created by the logged-in user?
I have a column with a trigger formula adding the users email as creator (but it is hidden from the users). Now I want to use that colum as a reference and if the email is equal to the users email logged-in the row would be highlighted in a pale yellow or green.
Thank you in advance.