Fill in null value from condition below?

Hello,

I’m trying to fill in a null cell above based on the condition that’s underneath. I can't seem to get the + and - formula correct based on the condition.

Edit: my mistake here is the file example attached. If the value below is pizza, then the null cell above needs to turn into 4. When it gets to a blank cell it needs to look at the cell below, candy, and change the null value to 6. The file named subteam test final is the result needed.

This was the formula I was trying:

IF IsEmpty([Row+1:Subteam]=="Pizza") THEN [Row-1:Subteam]=="4"

ELSEIF IsEmpty([Row+1:Subteam]=="Candy")

THEN [Row-1:Subteam]=="6"

ELSE (subteam) ENDIF

Example1.yxmd

subteam test before.xlsx

subteam test final.xlsx

Help

Accepted answers

ncrlelia

Hi @Arno_M,

I missed out the highlighted 'ELSE'.

Cheers,

Lelia

All comments

mst3k

your spreadsheet isn't embedded so we can't run the workflow, an alternative would also be to just put a few rows of data into a text input tool.

so i can't run it, but it sounds like what you're trying to do is if it's empty, fill in using the value from the next row, in which case i think if you just change your formula to this it will work? you'l have to make sure your data is sorted in some way first, or you won't be able to always know what's in the next row. you could also run into problems if the row beneath that one is empty for some reason too