Tracking product lifecycle

Heald33

What is the best way (if there even is a way) to track the lifecycle of products that we are producing. The current product lifecycle is:

1. Creation
2. Forming
3. Cutting
4. Quality
5. Shipping
6. Close

I currently place a status for each part when a PO comes in. When the status is "Forming" it gets put into the Forming Schedule. I would like to:

1. Update that status from the chart so that it sends it to the CNC Schedule, but also updates it on the Open Orders Log, and so on.
2. Have dependencies or something so when a part is added to a schedule, it goes to the end of the line, with whatever duration I have set for that part.

Is this even possible?

Andrée Starå

https://community.smartsheet.com/discussion/128242/tracking-product-lifecycle

Hi,

I hope you're well and safe!

Seems possible!

Can you share some screenshots? (Please delete/replace any confidential/sensitive information before sharing.) That would make it easier to help.

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

Heald33

I want to modify my initial question.

I have an Open Orders Log that will act as the "Master" and also, Step 1. I know how to copy or move cells from this sheet to another sheet, based on the Status.

What I want to be able to do is:

1. Have the status update in the Master so that I know what step that row is on.
2. Automatically have the start date start after the end date of the last entry, and the end date be entered based on a predetermined duration.

Alan_CMI

It doesn't seem you received an answer here. Did you? I am interested in the same solution.

Heald33

I have found that if I make my "children" sheets as reports, making a change on the report will update the "master" sheet