I have a view with the "Last Modified" field showing, I want to know how many records are being added daily is there a way for this? Also it seems that 100 records got "Modified" today, how can I check if this was a new record or existing record that was edited?

  • Does anyone know?
    – Raymound
    Commented Jun 29, 2015 at 18:08

2 Answers 2


In the View Settings:

  • Add the Created and Modified dates to your view
  • open the Group-By section and group by the your date field.
    sort Descending
  • Open the (View) Totals section (below the Group By) and Total by Count for your date field

Group the view by the 'last modified' date - it will group on the date only, not including the time. The 'header' for each group will show the counts - if you set it to start in collapsed mode it will be easier to see the totals.

As far as checking whether they are modified or new, you can check to see whether Modified is equal to Created. Can't do that in a view, so I'd do a calculated field with the calculation =IF([Created]=[Modified],"New","Modified") and filter on that field.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.