Incrementally increasing a number daily in a cell

09/15/21
Accepted

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.

Best Answer

  • Andrée StaråAndrée Starå ✭✭✭✭✭
    Accepted Answer

    @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([email protected], [Helper Date]@row), 
    NETDAYS([email protected], TODAY()))
    

    Make sense?

    Would that work/help?

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Answers

Sign In or Register to comment.