How to return the value of an adjacent cell for a summary sheet to show phase or step in a process


How can i use an IF statement to return the value of the adjacent cell in the PHASE column for a status cell that is IN-PROCESS. Or is there an easier way?

For any Status of IN-PROGRESS, i want to return the Adjacent same row Phase value.

From below something like:

If Status column = IN-PROGRESS then show Phase column adjacent (Firm SOW and Order draft)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!