increment counter when list item status field changes to active using OOTB list formula

Question

I need to increment the counter of Noofassignments column based on the status value Active, whenever status is getting changed as active then i need to increment 1 to the Noofassignments field with simple list formula

Answer 1

Hi @sweetu ve ,
You should have many status columns, increment 1 to the Noofassignments field(calculated column) every time one of the status columnsis "Active", right?
Please use the following formula: =IF(status1="Active",1,0)+IF(status2="Active",1,0)
The running effect is as follows (the value of Noofassignments shows how many ”active“):

---

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.

Answer 2

Thanks for your inputs

I am not having 2 status fields ,pls refer below list schema where status is active and whenever status is modified to active then we are getting modified status active count and increment to the Noofassignments column

I got Noofreplacements columns where we need to increment the counter of that field whenever Noofassignments counter getting incremented.

Answer 3

Hi @sweetu ve ，
Unfortunately, after my attempts, there is no way to use the OOTB list formula to realize the function of the counter. We cannot record the result of the last counter, so the life of the counter is only once.

---

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.

Answer 4

Hi @sweetu ve ,
After my search and research, we can count static counters, such as the total number of items in a list. But as you describe, continue to calculate the next count based on the previous count, which we currently cannot achieve.
Thank you for your understanding and 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.