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?