JESSETORGERSON
2 years agoQrew Member
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
------------------------------