Incrementally increasing a number daily in a cell

Justin Mauzy

I want to have a number incrementally increase by 1 each day until a checkbox is selected in another column.

There are 2 columns named:

• Days Lost (Column type Text/Number)
• Team Restarted (Column type Checkbox)

If I put a 1 into a cell (Row 1) in the Days Lost column, I want it to change to 2, the following day. If the checkbox is checked in the Team Restarted column of Row 1, then the number would stay as 1.

I am using Row 1 for both examples.

So in this instance, the number in the Days Lost column would change from 1 to 2 because the Team Restarted column is not checked and it is the following day. I would need the number to increase by 1 each day, until there is a checkmark in the Team Restarted column.

In this instance, the number in the Days Lost column would stay as 1 because the Team Restarted is checked.

Thanks in advance.

Andrée Starå

@Justin Mauzy

Ok.

I'd recommend something like this.

• Add a so-called helper column. Helper Date
• Add a Record a Date Workflow that records the date in the column when the Team Restarted Checkbox is checked.
• Add something like this to the Days Lost column.

=IF([Team Restarted]@row = 1, NETDAYS(Date@row, [Helper Date]@row), 
NETDAYS(Date@row, TODAY()))

Make sense?

Would that work/help?

Andrée Starå

Hi @Justin Mauzy

I hope you're well and safe!

How many Days Lost can there be as a max?

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!

Justin Mauzy

It could really be endless but I would say no more than 90 days max.

Thank you.

Andrée Starå

@Justin Mauzy

Ok.

I'd recommend something like this.

• Add a so-called helper column. Helper Date
• Add a Record a Date Workflow that records the date in the column when the Team Restarted Checkbox is checked.
• Add something like this to the Days Lost column.

=IF([Team Restarted]@row = 1, NETDAYS(Date@row, [Helper Date]@row), 
NETDAYS(Date@row, TODAY()))

Make sense?

Would that work/help?

Justin Mauzy

Worked perfectly! Thank you for all of the help.

Andrée Starå

@Justin Mauzy

Excellent!

You're more than welcome!