Workflow formula: Increase cell by value

Hi,

have been searching for this answer but with no success.

I would like to register number of:

  • due date revisions/changes
  • row modification changes

I tried to use "update cell" workflow, but this would require to have multiple conditions and results to do simple task of "increase value by 1", so simple formula when "cell" changes" workflow would do "cell+1"


Any idea how to do this?

Best Answer

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

    Hi @Mitja Rudel

    I hope you're well and safe!

    One possible solution could be to add a so-called helper sheet where you copy the row each time and then use cross-sheet formulas to count the number of rows (changes).

    Make sense?

    Would that 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 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.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!