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.
2 Likes
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 https://monday.com/developers/apps/manage
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 monday.com 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 monday.com 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. 
It seems like now has found a solution so I will share mine! I used automations that look like this:
2 Likes
Thanks a lot @AndreSpivo, works!
Posible great feature for monday.com in the future to request
Hey @Franco 
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 monday.com developers.
If you need help building custom integrations, we also have an option for paid assistance through our network of certified monday.com 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 
Cheers,
Jenna
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.