Count the number of times a specific change has been made to a column/item using a Formula (Counter: +1 on status)

Hello, I want to build a counter that +1 every time a status goes to a specified status.
Is it possible with a formula column.


Hello @Franco,

One way to do it would be to use the IF or SWITCH functions inside the formula, linking each status to a number. Depending on the number of statuses it can be a long formula but it will work.
Hope it helps,

Hello @PedroM

Thank you for the suggestion.
It is not one number i want to use it has to count each time the status of the same puls is set to “revision”. So first time status “revision” is 1, second time status “revision” the number has to change to two. this wil be in the same pulse.

Hi @Franco

This would not be possible with a Formula column. With monday apps you could develop an integration / automation that looks like:

When STATUS changes to SOMETHING increase this NUMBER with one

which than can be used on your board(s) as any other automation.

Can you direct me to information on how to get started with this?

A good place to start is

Just to be clear: developing a monday app requires programming skills and environment and it is still beta. I am developing some integrations ans as soon those can be uploaded to other accounts I will introduce a marketplace for these integrations.

1 Like

Hi @basdebruin, how you could make an automation from monday apps?
I cant see this avaliable on “Features”, screenshot:

Hi @hlopezvc

It is under Integrations and you integrate with itself. With Integrations feature you can build sentences like this one:

and add it to your board just like any other builtin automation.

PERFECT!!! I will try,…

@AaronRipper-Enable and his team have made a Gamification app for that uses the activity log to look at changes. The same adaptation can be modified to present the revision version.

HI @Franco

How did you end up creating the counter? We need some function like this to count revisions being done to a task

I never made the counter, i don’t have programming skils to make the app. :unamused:

It seems like now has found a solution so I will share mine! I used automations that look like this:


Thanks a lot @AndreSpivo, works!

Posible great feature for in the future to request

Hey @Franco :wave:

At the moment, we do not have the internal capabilities to count the number of times a specific change has been made in an item and have it displayed in a formula.

You can see the most recent change was made to an item using The Last Updated Column but for any specific changes and when they were made, you’ll need to check the Item Activity Log.

Otherwise, something you can always try instead would be to use one of our 3rd party platform integrations to build your own automation to count the number of times a specific change has been made in an item:

As mentioned earlier, if you are comfortable coding or have access to any developers, you can also build your own app/automation using our API:

If you need additional support on our APIs or apps platform, I would recommend doing a search for your question in our developer community here. You can also post to the community to get help from other developers.

If you need help building custom integrations, we also have an option for paid assistance through our network of certified partners. If this interests you, simply fill out this form and someone will be in touch shortly!

I hope this helps! Remember to mark as solved if this answers your question :slight_smile:


This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.