How to change status for one product type when a new item is added with the new status.

BWheel ✭✭
edited 11/11/22 in Add Ons and Integrations

Hello, I am tracking project submissions in a smartsheet list. Each project may has more than one phase, so the project steps appear in separate lines. When someone submits the final step, I would like the status column next to each step of the project to show "complete" (or checked).

I think this would be a workflow solution, but I can't come up with a formula to make this work.

Here it is visually

I want the check boxes in "Project Complete" to be checked as soon as someone triggers it in the "Is this completed?" column.


Best Answer