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]
Solved! Go to Solution.
Hey @kceesay is this what you're looking for? Just need to work the other way around and look downwards if so:
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
Yes this worked thank you!
Yes, you're right I should've been looking down a row vs up one thank you!