really rusty and losing my mind over this formula field im trying to make. just a free form text field on Item, that should display 'true' based on 2 checkbox conditions this rendered null on an item that has custitem27 checked, and custitem_field_remove_preorder unchecked. I've tried switching the = to != and also checking for false being null but it still doesnt render or renders the opposite value

CASE WHEN {custitem27} = 'T' AND {custitem_field_remove_preorder} = 'F' 
THEN 'true' 
ELSE null
END

do comparisons to 'T' or not 'T'

doesnt work

both 'F' and null can represent not checked

NVL()

can be useful here

yea ive already tried to do != 'T' but also doesnt work, that's how i tried it the first time hah. I''ll see if nvl can help

Do you have ‘store value’ checked?

Are one of those fields new? I have found a similar thing in the past (long time ago, so I am trying to remember). I think it was because the field was new and the value was neither true nor false (i.e. it was Null because the value hadn't been set yet - in the UI it looked unchecked though). Then the item was edited and saved, it set the value to false (if it wasn't checked of course).

nope store value wasn't checked, and the fields weren't new and I had already tried several options to handle the "null"

Then I am stumped. I have tested it in my system and it worked fine. Have you tried two different checkboxes, just to be sure?

i didnt try that, honestly it worked with the saved search summary option so im just gonna chalk it up to hashtag netsuite for this time hah