Check your if statement - if you’re using a checkbox on your sheet that could be part of it. I had an issue where I was testing a checkbox to be true, and I didn’t need to. My mistake was this:
It ALWAYS returned the value in B4 for me. After some checking, I found out i didn’t need the “TRUE” because it was a checkbox. If it’s checked, it’s TRUE, if not, it’s FALSE. All i needed was
This gave me the TRUE when the box was checked, returning the value in B3
Hope it helps.