Good afternoon gurus! Here is our question of the week!
I have a process that follows a material through different stages of release. This process spans across multiple sheets, some sheets containing multiple steps in the process. I had a "status" column requiring manual updates, but time has shown that automation would be much better in this case.
I need help building a formula to show the correct status of a material at any stage of the process. I'm guessing an IF statement about a mile long will be in the works. Any ideas? Thanks in advance!
Here are the different statuses of the process:
Ordered by Procurement
Received by S/R
Submitted to QC
In Review (QC)
Released by QC
** These are "special cases" and wouldn't be part of the normal workflow.
Help Article Resources
Check out the Formula Handbook template!