Update Cell Workflow to change row Status
Looking to update the status of a row to 'Complete' once the % complete = 100. I put together the below workflow for that action and it does not work. Can't figure it out.
Trigger: when rows are changed
when % complete changes to:
100%
Run workflow: When triggered
Change cell value
Change cell value in : Status
Complete
Best Answer
-
That's pretty weird. Next stop may be Smartsheet support. I've heard of others having sheets where workflow just stops working due to some background corruption.
I tested this and it worked just fine. Updating a column with single-select drop down and a regular text/number column:
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers
-
How is your value of 100% being generated? Manual entry? Formula from other cells on the same sheet? Or via cross-sheet link or function?
Manual entry should work to trigger change a cell value workflow.
A formula from other cells on the same sheet MAY trigger change a cell value workflow, depending on how the other cells are populated.
A change from a cross-sheet link or function will NOT trigger a change a cell value workflow.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Hi Jeff,
The % complete and the status columns are both manual entry. There are no cross-sheet links anywhere in the sheet, but I do have formulas in other cells.
The cells with formulas reference the status and % complete, but I wouldn't think that matters, does it?
-
No that shouldn't matter.
Let's check how you're entering the percentage. Is the column formatted for %, or just regular text/number? In other words, do you enter "100%" in the column, or just enter 1 and the column interprets that as 100%? The system interprets 100% in a percent-formatted column to actually be a numeric value of 1. So try changing your trigger to be where % Complete = 1 and see if that works.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Yep, I tried that thinking that would fix the issue and it did not take.
-
That's pretty weird. Next stop may be Smartsheet support. I've heard of others having sheets where workflow just stops working due to some background corruption.
I tested this and it worked just fine. Updating a column with single-select drop down and a regular text/number column:
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Hi @spopres
I hope you're well and safe!
To add to Jeff's excellent advice/answer.
Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)
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.
-
I'm not entirely sure why it started working for me, but it does now. Pretty straightforward. Jeff's input above and screenshot take care of issue.
-
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
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!