You need to sign in to do that
Don't have an account?
Felix Quinones
Custom formula field receives error when value is left blank.
Hello All,
I'm trying to fix the following formulas that are showing an error when the value is left blank. In our object, black field are important because means that they do not apply. The fields that are showing an error are Q1 Results and Q1 Flag.
Field: Q1 Results
IF(
ISNULL( Q1_Validation__c ),
NULL,
Q1_Value__c / Q1_Goal__c
)
Field: Q1 Validation
IF(
AND(ISBLANK(Q1_Goal__c ),ISBLANK(Q1_Value__c )),
NULL,1)
Field: Q1 Flag
(
IF( ISBLANK(Q1_Goal__c ) && ISBLANK(Q1_Value__c ),
IMAGE("https://i.ibb.co/PzwzmbZ/blue-flag.png", " Blue Flag"),
IF(ISBLANK(Q1_c__c ),
IMAGE("https://i.ibb.co/PzwzmbZ/blue-flag.png", " Blue Flag"),
IF (Q1_c__c <= 0.80,
IMAGE("https://i.ibb.co/02GzKqM/red-flag.png", " Red Flag"),
IF (Q1_c__c <= 0.90,
IMAGE("https://i.ibb.co/59L8GnF/yellow-flag.png", " Yellow Flag"),
IMAGE("https://i.ibb.co/1KNswzk/green-flag.png", " Green Flag"))))))
I appreciate all your help.
I'm trying to fix the following formulas that are showing an error when the value is left blank. In our object, black field are important because means that they do not apply. The fields that are showing an error are Q1 Results and Q1 Flag.
Field: Q1 Results
IF(
ISNULL( Q1_Validation__c ),
NULL,
Q1_Value__c / Q1_Goal__c
)
Field: Q1 Validation
IF(
AND(ISBLANK(Q1_Goal__c ),ISBLANK(Q1_Value__c )),
NULL,1)
Field: Q1 Flag
(
IF( ISBLANK(Q1_Goal__c ) && ISBLANK(Q1_Value__c ),
IMAGE("https://i.ibb.co/PzwzmbZ/blue-flag.png", " Blue Flag"),
IF(ISBLANK(Q1_c__c ),
IMAGE("https://i.ibb.co/PzwzmbZ/blue-flag.png", " Blue Flag"),
IF (Q1_c__c <= 0.80,
IMAGE("https://i.ibb.co/02GzKqM/red-flag.png", " Red Flag"),
IF (Q1_c__c <= 0.90,
IMAGE("https://i.ibb.co/59L8GnF/yellow-flag.png", " Yellow Flag"),
IMAGE("https://i.ibb.co/1KNswzk/green-flag.png", " Green Flag"))))))
I appreciate all your help.
Try Below Formula Please Mark It As best Answer If It Helps
Thank You!
All Answers
Try Below Formula Please Mark It As best Answer If It Helps
Thank You!