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

------------------------------