This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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"
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
IF IsEmpty([Subteam]) THEN [Row+1:Subteam] ELSE (subteam) ENDIF