Iterative Cell Values

Kevin De Hart

I am attempting to utilize a formula to iteratively interact with a cell when a checkbox is checked. The idea being that I will have a checkbox called "No Change" which I can check during our weekly round robin meetings when part of a project has had no change. This would add 1 to the value in a cell named [NoChangeCount], and a workflow would revert the checkbox to unchecked. The formula would look something like this in a cell named NoChangeHolder: =IF([No Change]@row, NoChangeCount@row + 1)

The same formula in the cell named NoChangeCount returns #Circular Reference

The problem that I have is making this repeatable, if I uncheck the box the math reverts, and the value of NoChangeCount returns to 0, workflows do not allow math within the cell value, helper columns just turn into a cyclic version of the same problem.

Any advice or help would be appreciated, across 50 small projects this takes a decent portion of my Friday to do manually.

Andrée Starå

@Kevin De Hart

You're more than welcome!

It works great if you don't need the counter to go so high.

✅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!

Andrée Starå

Hi @Kevin De Hart

I hope you're well and safe!

There are at least two options.

1. Workflow to copy the row to a so-called helper sheet and then use cross-sheet formulas to count and collect how many times it's been copied.
2. Workflow with condition paths combined with the Change a Cell Action to change the count each time you check the box

Would any of those options 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!

Kevin De Hart

Thank you for responding so quickly.

I would be very interested in seeing how the, "change a cell" action could work as I had given up on that already.

I don't see copying to a helper sheet as reasonable, due to the rapid processing of minor jobs I would quickly have hundreds of sheets.

Andrée Starå

@kevin de hart

Happy to help!

It would look something like this.

Make sense?

✅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!

Kevin De Hart

I hadn't considered this, thank you sir!

Andrée Starå

@Kevin De Hart

You're more than welcome!

It works great if you don't need the counter to go so high.

✅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!