Automated workflow is not updating cell

Enusmith

I have set up an Automated Workflow so that when the cell in the Status column is set to Complete, the cell in the % complete column should update to 100%. If I try Run Now or Test now it will update all % complete cells to 100 regardless of what is in the Status column.

Paul Newcome

There is a note in the Run Now window that says it will ignore triggers and only look at condition blocks. If you do not have any conditions, this will update all rows. You will need to include a condition in the automation if you wnat to use the Run Now feature.

Enusmith

Thanks Paul. The main issue I would like to solve here is having the sheet update the % complete to show 100% when I change the cell in the Status column to Complete. That being said, I added a condition, and it still changed all cells to 100% when I ran the test.

Paul Newcome

Is it changing on all rows, or rows that are marked as Complete?

Enusmith

It is updating all the % complete rows to 100 even though all the Status rows are blank.

Paul Newcome

In that case, you may need to reach out to support. It shouldn't be doing that with the condition in place.

Enusmith

Ok. Thanks so much for your help, Paul.