Hi Guys,
I am struggling with this Multi Row Formula which I have the following:
TEST |
false |
false |
true |
false |
false |
close |
false |
false |
true |
false |
close |
false |
|
What i need is the following output
TEST | Result |
false | false |
false | false |
true | true |
false | true |
false | true |
close | false |
false | false |
false | false |
true | true |
false | true |
close | false |
false | false |
false | false |
I would appreciate any advise.
Kind Regards,
Dan
Solved! Go to Solution.
@DanielCarro if I understand the requirement properly you can use the below formula. Example is attached as well. Please mark the thread solved if this fit your needs.
if [TEST] = "close" then "false"
elseif [Row-1:Result] = "true" then "true"
else [TEST] endif
Hi @griffinwelsh , it worked perfectly