Update Cell Workflow to change row Status

spopres · 03/08/22

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

Jeff Reisman · 03/08/22

https://community.smartsheet.com/discussion/comment/321926#Comment_321926

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:

Jeff Reisman · 03/08/22

@spopres

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.

spopres · 03/08/22

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?

Jeff Reisman · 03/08/22

https://community.smartsheet.com/discussion/comment/321919#Comment_321919

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.

spopres · 03/08/22

Yep, I tried that thinking that would fix the issue and it did not take.

Jeff Reisman · 03/08/22

https://community.smartsheet.com/discussion/comment/321926#Comment_321926

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:

Andrée Starå · 03/08/22

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!

spopres · 03/09/22

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.

Andrée Starå · 03/09/22

@spopres

Excellent!

Glad you got it working!

Update Cell Workflow to change row Status

Best Answer

Answers

Help Article Resources

Categories