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
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!