I have a section on our Opportunity that creates a Text formula based on if a box in column A is ticked and the same box in column B is not.
For example, if we request Item 1, we tick the first box, and we don't tick the second box until we receive Item 1. This formula field creates an easy to read list of items that are outstanding, so that I can pull it into email notifications.
The formula has a load of code, but this one is creating a line break when I want it to be NULL.
IF( NOT(ISBLANK(TEXT( Requested_Proof_of_ID__c))) && Received_Proof_of_ID__c = true , "", TEXT(Requested_Proof_of_ID__c) + BR()) &
Does anyone have any idea to make it so that when the IF statement equals TRUE, the formula just create a null and not a line break? I only want the line break if the formula equals FALSE and puts the TEXT() in. I've tried different operators and moving the BR(), but I just can't get it to not create the line break.