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.
6 answers
OMG thank you Kapil! You made me realise that, yes, my code was ALWAYS false, even when it met true. I rewrote the code to the below, and it works now. I think my brain just turned off for a minute there! IF((NOT(ISPICKVAL( Requested_Proof_of_ID__c , "" )) && Received_Proof_of_ID__c = false) , TEXT(Requested_Proof_of_ID__c)+ BR(), NULL) &
