SharePoint List Cumulative row by row for same year

Question

I have a SharePoint List, how to create a column to show cumulative sum row by row with incremental date in same year?

When it is next year, the cumulative will restart from year start.

Answer 1

Hi @c__i ,

According to your description, there is currently no way to directly set it in the SharePoint list. You can try using Power Apps and Power Automate to achieve this.

I found two similar posts, hope they can help you:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Power-App-auto-increment-field-in-share-point-list/td-p/1210117

https://powerusers.microsoft.com/t5/Building-Flows/Automatic-custom-increment-to-SharePoint-column/td-p/2084241

However, currently Power Apps and Power Automate are not supported in Q&A. If you have more detailed needs, you can go to Power Apps Community and Power Automate Community to start a new discussion and get more targeted support.

Thank you for your support! :-)

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.