Iterative Cell Values

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.

Find more posts tagged with

Accepted answers

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!

All comments

Andrée Starå

Hi @Kevin De Hart

I hope you're well and safe!

There are at least two options.

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.
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?

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.