Count number of update of a cellul

Eric Laitenberger

Hello,

I would know how can I create a formula to count how many time a cellul has been updated

Could you help me

Andrée Starå

Hi @Eric Laitenberger

I hope you're well and safe!

I can think of two methods.

• Workflow that copies the row to another sheet and then you'd count how many rows with a formula and collect it back to the main sheet.
• Workflows that trigger on the change and change the value to the next number for each (1,2,3, and so on).

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Eric Laitenberger

Eric Laitenberger

Hi @Andrée Starå

For the second solution , I would like that after each change it will be +1, What I have to write it?

Andrée Starå

@Eric Laitenberger

It would look something like this (continue the pattern)

Make sense?

Would that work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Eric Laitenberger

@Andrée Starå

Thanks a lot

Andrée Starå

@Eric Laitenberger

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Eric Laitenberger

@Andrée Starå

In term of formula, could you help me?

I would like find a formula to calculate the number of days out of office

I have just a period

For example From 01_jun_2022 tp 24-AUG-2022, and I would like know the number of days per mont (workday)

Could you help me