Wonderful. Quick important question -- how do we validate correctly the following business logic? If status = 'Cancelled' then 'Cancellation Reasons' cannot be null ALSO IF Status = canceled AND Cancellation Reasons ='Others', THEN Other 'Cancellation Reasons' != null ------------------------------------------------------------------- I have tried following but doesn't validate :( IF( AND( ISPICKVAL(Status, 'Canceled'), NOT(ISPICKVAL(CancellationReasons__c, 'null'), AND(ISPICKVAL(Status, "Canceled"), ISPICKVAL( CancellationReasons__c ,'Others'), Other_Cancellation_Reasons__c= '') ) ),false,true) IF(logical_test, value_if_true, value_if_false)
IF( ISPICKVAL( StageName , "Prospecting") && ISPICKVAL( Type , "New Customer") , ISBLANK( Description ) , false) can be used as well instead of nested if? it works i guess
Thank you for the clarification. That's explained well))
New subscriber here, thank you so much
Nice explanation
Very useful video!!! Thank you very much! ❤️
Thank you!!
will u pls continue your channel, upload more pls
Wonderful. Quick important question -- how do we validate correctly the following business logic?
If status = 'Cancelled'
then 'Cancellation Reasons' cannot be null
ALSO
IF Status = canceled AND Cancellation Reasons ='Others',
THEN Other 'Cancellation Reasons' != null
-------------------------------------------------------------------
I have tried following but doesn't validate :(
IF(
AND(
ISPICKVAL(Status, 'Canceled'),
NOT(ISPICKVAL(CancellationReasons__c, 'null'),
AND(ISPICKVAL(Status, "Canceled"),
ISPICKVAL( CancellationReasons__c ,'Others'),
Other_Cancellation_Reasons__c= '')
)
),false,true)
IF(logical_test, value_if_true, value_if_false)
IF( ISPICKVAL( StageName , "Prospecting") && ISPICKVAL( Type , "New Customer") , ISBLANK( Description ) , false)
can be used as well instead of nested if? it works i guess
Yes, it would work!
But why are there two FALSE at the end? The last False refers to the first main IF and the second False refers to?
If you look clearly, there are two IF as well. The inner false is for inner IF and outer False is for outer IF.