# Iterative Cell Values

Options

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.

• ✭✭✭✭✭✭
Options

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!

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭✭
Options

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!

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Options

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.

• ✭✭✭✭✭✭
Options

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

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Options

I hadn't considered this, thank you sir!

• ✭✭✭✭✭✭
Options

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!

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!