Cell update automation

mscott4378 · 07/06/22

I have a status column with list of 5 items, one of which is "completed" and a Percent Complete column text/number with formatting as a percentage. I have attached the automation, but it never updates the Status to complete when the Percent Complete is 100%

Leibel S · 07/06/22

How does the percent complete change to 100%, if it depends on a cross sheet reference and/or a cell link then it will not work (as per Smartsheet's design).

mscott4378 · 07/06/22

The Percent Complete update by the task owner or myself. It is freeform text field we enter the value. There is no external or internal link to another cell.

Paul Newcome · 07/06/22

How is the Status column being updated for the rest of the options?

mscott4378 · 07/12/22

Not sure what you are asking. Today the % Complete and Status are manually updated. I would like to create an automation to automatically update the Status field to "Complete with the % Complete is 100%. There are other status in the Status column, not started, in-progress, etc.

Paul Newcome · 07/12/22

Try adjusting your trigger so that it runs when % Complete changes to 1.

mscott4378 · 07/14/22

That worked, thanks for the help

Paul Newcome · 07/15/22

Happy to help. 👍️

Cell update automation

Answers

Help Article Resources

Categories