JESSETORGERSON
Qrew Member
Joined 4 years ago
User Profile
User Widgets
Contributions
Formula for Counting Notes in a Field by User
I've created a formula (thanks to the help from this community) that gives me a tally of the number of times a specific record has been modified. This works perfectly. However, I'd like to break this count down by user. For example, if a record was modified 4 times, I'd like to see that John Smith modified it twice and Jane Smith modified it twice. Any ideas? For reference, I've used the following formula to tally the modifications: Count( Part([Log Notes],2,"]"), Part([Log Notes],3,"]"), Part([Log Notes],4,"]"), Part([Log Notes],5,"]"), Etc. ------------------------------ Jesse T ------------------------------37Views0likes1Comment