Formula to show Current Status of Project Approval
Not sure if this would be accomplished easier with a Formula or with a Update Cell Workflow.
We have a Projects Smartsheet that have 4 different Reviewers that need to approve. I'm looking to add another column for Reporting purposes that will show what approval step each project is on.
For example, based off my attached screenshot I'd like to have a formula in a new "Current Status" column return that PTP Name UPS Annual is "Pending Dell FM Review".
I'm a beginner with Smartsheet formulas, but was thinking there is an IF statement I could write to pull this off.
Any suggestions would be greatly appreciated!!!