IF and BLANK nesting formulas

RNYQUIST

I am trying to use an IF statement in the approved column that says "If status is requested, return PIPELINE, all other statuses return APPROVE, unless it's blank then leave the cell blank". Everything I try returns #UNPARSEABLE.

I had it working but someone messed with my sheet and now I can't get it back! Help :)

DKazatsky2

Hi @RNYQUIST,

Give this a try.

=IF(ISBLANK(Status@row), "", IF(Status@row = "Requested", "PIPELINE", "APPROVE"))

Hope this helps,

Dave

DKazatsky2

Hi @RNYQUIST,

Give this a try.

=IF(ISBLANK(Status@row), "", IF(Status@row = "Requested", "PIPELINE", "APPROVE"))

Hope this helps,

Dave

RNYQUIST

Worked beautifully. I swear I tried this 😂 I must have missed either a quotation or parenthesis.

Thank you so much!