cross-sheet reference, colored balls & workflow

I have 2 sheets that are communicating successfully. Sheet A has a column called "Application Status" that displays a red, yellow, or status green ball depending on a formula that references Sheet B:

=IF(INDEX({Sheet B-RoutingProgress}, MATCH([Project #]@row, {Project#}, 0)) = "Yellow", "Yellow", IF(INDEX({Sheet B-RoutingProgress}, MATCH([Project #]@row, {Project#}, 0)) = "Green", "Green", "Red"))

This formula works fine -- the colors change as they should depending on what's going on in Sheet B.

My problem is that there is a Move Row workflow built into Sheet A that says that when "Application Status" changes to "green," that row should move to Sheet C. This isn't happening. Everything with the workflow is simple and appears to be in order (see screenshot below) which makes me think that for some reason the workflow isn't seeing the "Application Status" as "green" even though it's correctly displaying that way, based on the formula. (Could it be because the content of that cell actually never changes, because it's a formula?)

Thoughts?


Answers

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

    Hi @Amanda Paveglio

    I hope you're well and safe!

    Unfortunately, it's not possible at the moment, but it's an excellent idea!

    Please submit an Enhancement Request when you have a moment.

    More info.

    Actions that will automatically modify the sheet cannot be triggered by inbound cell-links or cross-sheet formulas. This includes Request an approval, Move rows, Copy rows, Lock rows, and Unlock rows. For example, if the Status cell on the row is populated by a cell link with a value from another sheet, changes to that cell value through the cell link will not trigger a workflow that locks the row when Status changes to Complete.

    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 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!

    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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!