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

joseph_mojo

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)

BullandKhmer

=IS(Status@row="IN-PROGRESS",Phase@row,"")

joseph_mojo

I am trying this, thank you…

=IS(Status@row="IN-PROGRESS",Phase@row,"")

Is this correct? I am getting an UNPARSEABLE returned.

joseph_mojo

updated it to IF and still unparseable

=IF(Status@row="IN-PROGRESS",Phase@row,"")

Andrée Starå

Hi,

I hope you're well and safe!

I noticed in another post that you're using the formula in the Sheet Summary, but you can't use the @row feature because it doesn't know which row you want.

Can you elaborate more specifically on what you want to show in the Sheet Summary?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!