Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

Counter for Title in Sharepoint

Screenshot (20)_LI.jpg




Hello All,
I want a Counter for my List in Sharepoint for the Title. I have tried this, it works but If i delete an Item in Sharepoint, then this happends : (I delete Title 1 for example)
Title         ------> Title
1                            2

2                            3

3                           if I add new Count then it cames 3


I hope someone can Help me 🙂 Thanks.


Advocate II
Advocate II

Hello @Fatih1,


If I understood you right, the value will show three because you have the +1 after CountRows. If you remove "+1", it will count only the rows in the list. 


Hey NP1, I know that I need another way to make a counter for the Title.


Why? What doesnt work for you in CountRows?


If I delete the new entry should be get the highest title number. 




Could you please let me know wht is exactly your requirement?


Do you want the last entry +1 in title? OR, last saved+1? (even it is deleted)


let me explain with an example:

Title   (delete 2)                 Title

1                                         1

2                                         2

3                                         3

4                                         4 



So if I delete that the place is getting another one. 



Title (delete 2)                               Title

1                                                       1

2                                                        3

3                                                        4  

4                                                        5



One of this two options i want 


Community Support
Community Support

Hi @Fatih1 ,

Do you mean that the count function counts include blank value?

If so, I suggest you try this formula:


If you use countif function, you could exclude the items that have empty value.

Here's a doc about this function for your reference:



Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.


So If I count Title everything is okey. 









If I delete the Entry Title 1,








And put a new entry in my list, then this happens. I want that he show me Title 3, Not 2 again

Screenshot (29).png





To fulfill your requirment, there is another simple way,


Create a speerate list with only having Title field.

Update this new list title field with +1 every time when your main doc is submit.

Sets your main doc title field with value of existing counter title value from new list.




Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (7,301)