Formula

Susan Fernald

I am looking for a formula for a new sheet that looks at a column and if it equals "In Process" would input the value of another cell?

Paul Newcome

You would want something like this...

=IF([Column Name]@row = "In Process", [Other Column Name]@row)

MVP OPS

Hi @Susan Fernald

This is the perfect use case for the index match formula. Something like this below.

if(status@row="In Process", index({other sheet value column}, match(project@row, {other sheet project column}, 0))