If statement for rows??

Hi everyone,

I am trying to build an IF statement to read each row for values containing "rp" and replace the row above with "Tree" using the multi row formula. I keep running into issues any idea how I can troubleshoot?

IF (Contains([F2], "rp")) = "TRUE"
THEN[Row-1:F2] = "Tree"
ELSE [F2]

Workflow

Datasets

Error Message

Tips and Tricks

Accepted answers

Felipe_Ribeir0

Hi @kceesay

Try this formula

IF Contains([Row+1:F2], "rp") then
"Tree"
ELSE [F2]
ENDIF

contains.yxmd

All comments

Felipe_Ribeir0

Hi @kceesay

Try this formula

IF Contains([Row+1:F2], "rp") then
"Tree"
ELSE [F2]
ENDIF

contains.yxmd

DataNath

Hey @kceesay is this what you're looking for? Just need to work the other way around and look downwards if so:

Look for rp MRF.yxmd

ShankerV

Hi @kceesay

Please use the below IF statement.

IF (Contains([Row +1:F2], "rp"))

THEN "Tree"
ELSE [F2]

ENDIF

IF Condition is True

THEN statement gets executed

ELSE ie. False statement gets executed.

ENDIF is necessary to end the condition.

Many thanks

Shanker V

kceesay

Yes this worked thank you!

kceesay

Yes, you're right I should've been looking down a row vs up one thank you!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703