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.
So my project consists of a list of company transactions. The information of certain transactions are in rows, which are sorted by column headers. I have a column named affiliate that is either empty or has an affiliate it pertains to. If the cell is empty, I want to paste "Non" in the next cell in the row under column header "entry" and if the affiliate cell has any affiliate I want to post "inter" in the entry cell. I tried an if statement using isNull but It is not working.
This is the example of my list. It says inter for both.. any advice?
Hi @all163 , my guess is that your cells are blank rather than null. I'd recommend switching over to the IsBlank() formula from IsNull(). If that doesn't work for you could you screenshot the formula you're trying to help with further troubleshooting? Thanks!
Maybe my data is very manipulated, because I am pulling from many different sources, but it unfortunately is not working. I have tried isNull, isEmpty and even = "" in my if condition. What can I provide for you to try and trouble shoot this?