Moving rows to other sheets with Workflow

What is wrong with my Workflow? When the % Complete column changes to 100%, I want the row to move to another selected sheet but it is not happening.


  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi Terry,

    Change the 100% to 1. 1 = 100%.

    Smartsheet looks at the numbers in a column formatted for percent (for example, a % Complete column) as values between 0 and 1.

    Use decimal values (examples: 0.25 for 25%, 0.5 for 50%) to get the correct comparison, as opposed to whole numbers.

    Did that work?

    I hope that helps!

    Have a fantastic week!


    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    ✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!


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

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

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • TeeM
    TeeM ✭✭
    edited 03/16/20

    Hello Andree,

    Unfortunately, that hasn't worked.

    We have conditional formatting applied where if a row is marked as 100%, a strike-through will be applied and the color of the text changes from black to grey. This works fine. (The rule in this case shows 100% as 1 as you have noted, but the cell shows as 100%)

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    How is the % Complete entered? Is it manual entry, formula, formula with cross sheet reference, or cell linking?

  • TeeM
    TeeM ✭✭

    @Paul Newcome

    It is a manual entry. Users update the % complete as they go. Once it is 100% complete, conditional formatting is applied and then the row is to be moved to another sheet. The conditional formatting is fine; just the moving currently needs to be done manually.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    In that case I would have to second @Andrée Starå's suggestion of changing it to look for 1 instead of 100%. If you have tried that and it is still not working, I suggest reaching out to support.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!