Status Updates

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:

Order Requested

Ordered by Procurement

Received by S/R

Submitted to QC

In-Testing (QC)

In Review (QC)

Released by QC

In Inventory

**Issues--Needs Attention


** These are "special cases" and wouldn't be part of the normal workflow.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!