Good morning,
I have 2 Sheets
- Master Production Schedule - consists of multiple columns, Job #, Job Name, Line 2 Count, Forms Submitted?, and Status
- Check List Submission - consists of multiple columns, Job #, Job Name, Line 2 Count, Submitted, Outstanding Entries, Missing Form Override(Checkbox), and Status
The idea is that when our line 2 production workers are in the final stages of quality they need to fill out a paper form and then upload some info and a photo of the paper form into the Smartsheet Check List Submission, The Line 2 count will reference the same column on the Master Production Schedule, the Submitted column will just count however many entries have the same Job #, Outstanding entries will just be Line 2 Count - Submitted.
* I believe I have mostly everything figured out, where I am struggling is if the job on the Master Production Schedule is marked off as complete in the Status column and there are still Outstanding entries on the check list submission I need the Status column (Check List Submission) and the Forms Submitted? column (Master Production Schedule) to both say "Missing Forms".
Automation will be set up as follows (Check List Submission)
If Status = Complete, move rows to Archive Sheet
If Status = Missing Forms, notify Production Supervisor
If Status = Overridden, move rows to Archive Sheet and notify Production Supervisor
I hope this is clear as to what I need help with, thank you for your time.