Skip to main content
Question

How can I create a formula to count the number of times a field has been modified?

  • October 12, 2016
  • 0 replies
  • 285 views

I have a multiple choice field, [ISR Calling Status], that logs the entries. I want to create a formula field that counts the number of times that field has been modified (timestamped). Is there a formula that I can write for this? Can't seem to find any suggestions.

Thanks much!

    This topic has been closed for replies.

    Try this

    var text value = [My text field which is logging the changes];

    Count(
    Part($value,1,"]"),
    Part($value,2,"]"),
    Part($value,3,"]"),
    Part($value,4,"]"),
    Part($value,5,"]"),
    Part($value,6,"]"),
    Part($value,7,"]"),
    Part($value,8,"]"),
    Part($value,9,"]"),
    Part($value,10,"]"),
    Part($value,11,"]"),
    Part($value,12,"]"),
    Part($value,13,"]"),
    Part($value,14,"]"),
    Part($value,15,"]"),
    Part($value,16,"]"),
    Part($value,17,"]"),
    Part($value,18,"]"),
    Part($value,19,"]"),
    Part($value,20,"]")
    )
    • DawnDawn
    • Author
    • Registered
    • October 12, 2016
    hmmm, tried that and it's returning a Syntax error (Possible culprits are a mismatched set of parentheses, missing quotes, or an extra bracket.) I can't see anything missing off-hand.
    I corrected the formula
    • DawnDawn
    • Author
    • Registered
    • October 12, 2016
    Mark...you ARE THE MAN! Worked like a charm! Thanks so much!!!
    • PAULPAUL
    • Registered
    • August 8, 2017
    Mark, is there a way to do this for a file field? I would like to count the number of revisions that have been uploaded to a file field, in order to use that revision count number for another formula. 
    Terms & ConditionsAccessibility statement