Workflow formula: Increase cell by value

Mitja Rudel

Hi,

have been searching for this answer but with no success.

I would like to register number of:

• due date revisions/changes
• row modification changes

I tried to use "update cell" workflow, but this would require to have multiple conditions and results to do simple task of "increase value by 1", so simple formula when "cell" changes" workflow would do "cell+1"

Any idea how to do this?

Andrée Starå

Hi @Mitja Rudel

I hope you're well and safe!

One possible solution could be to add a so-called helper sheet where you copy the row each time and then use cross-sheet formulas to count the number of rows (changes).

Make sense?

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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Mitja Rudel

I hope you're well and safe!

One possible solution could be to add a so-called helper sheet where you copy the row each time and then use cross-sheet formulas to count the number of rows (changes).

Make sense?

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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Mitja Rudel

Dear Andree,

thank you for idea, it will make the trick (with autonumber helping coloumn) but not as efficient as it could be :)

Andrée Starå

@Mitja Rudel

Excellent!

You're more than welcome!