Skip to main content
improved formatting
Source Link
Adrian Larson
  • 151.3k
  • 38
  • 247
  • 431

been going around on this. Can anybody spot whats the issue? I'm just trying to get a validation rule to work. Basically, if someone select a certain option in a picklist, I want to make sure that all the fields are populated.

I've tried a couple ways but I've gotten snagged on the Error: Field StageName is a picklist field. Picklist fields are only supported in certain functions.

Error: Field StageName is a picklist field. Picklist fields are only supported in certain functions.

I'll try to use the functions that are recommended in the documentation but I'll run into errors with that too. Can anyone spot the issue?

INCLUDES( StageName, "Final Proposal",
OR(
ISBLANK( Geography__c ),
ISBLANK( Languages__c ),
ISBLANK( Customer_Base__c ),
ISBLANK( Number_of_Agents__c ),
ISBLANK( Additional_Resources_Required__c ),
ISBLANK(  Program_Length_In_Months__c  ),
ISPICKVAL(  CRM_List_Requirements__c , 'N3 Provides'),
ISPICKVAL(  CRM_List_Requirements__c , 'Client Provided '),
ISPICKVAL(  Proposed_Commitments__c, 'KPI' ),
ISPICKVAL(  Proposed_Commitments__c, 'Metrics' ),
ISPICKVAL(  Proposed_Commitments__c, 'Results' ),
ISBLANK(  Non_Standard_Program__c  )
))

been going around on this. Can anybody spot whats the issue? I'm just trying to get a validation rule to work. Basically, if someone select a certain option in a picklist, I want to make sure that all the fields are populated.

I've tried a couple ways but I've gotten snagged on the Error: Field StageName is a picklist field. Picklist fields are only supported in certain functions. I'll try to use the functions that are recommended in the documentation but I'll run into errors with that too. Can anyone spot the issue?

INCLUDES( StageName, "Final Proposal",
OR(
ISBLANK( Geography__c ),
ISBLANK( Languages__c ),
ISBLANK( Customer_Base__c ),
ISBLANK( Number_of_Agents__c ),
ISBLANK( Additional_Resources_Required__c ),
ISBLANK(  Program_Length_In_Months__c  ),
ISPICKVAL(  CRM_List_Requirements__c , 'N3 Provides'),
ISPICKVAL(  CRM_List_Requirements__c , 'Client Provided '),
ISPICKVAL(  Proposed_Commitments__c, 'KPI' ),
ISPICKVAL(  Proposed_Commitments__c, 'Metrics' ),
ISPICKVAL(  Proposed_Commitments__c, 'Results' ),
ISBLANK(  Non_Standard_Program__c  )
))

been going around on this. Can anybody spot whats the issue? I'm just trying to get a validation rule to work. Basically, if someone select a certain option in a picklist, I want to make sure that all the fields are populated.

I've tried a couple ways but I've gotten snagged on the

Error: Field StageName is a picklist field. Picklist fields are only supported in certain functions.

I'll try to use the functions that are recommended in the documentation but I'll run into errors with that too. Can anyone spot the issue?

INCLUDES( StageName, "Final Proposal",
OR(
ISBLANK( Geography__c ),
ISBLANK( Languages__c ),
ISBLANK( Customer_Base__c ),
ISBLANK( Number_of_Agents__c ),
ISBLANK( Additional_Resources_Required__c ),
ISBLANK(  Program_Length_In_Months__c  ),
ISPICKVAL(  CRM_List_Requirements__c , 'N3 Provides'),
ISPICKVAL(  CRM_List_Requirements__c , 'Client Provided '),
ISPICKVAL(  Proposed_Commitments__c, 'KPI' ),
ISPICKVAL(  Proposed_Commitments__c, 'Metrics' ),
ISPICKVAL(  Proposed_Commitments__c, 'Results' ),
ISBLANK(  Non_Standard_Program__c  )
))

been going around on this. Can anybody spot whats the issue? I'm just trying to get a validation rule to work. Basically, if someone select a certain option in a picklist, I want to make sure that all the fields are populated.

I've tried a couple ways but I've gotten snagged on the 'Error: Field StageName is a picklist field. Picklist fields are only supported in certain functions.'Error: Field StageName is a picklist field. Picklist fields are only supported in certain functions. I'll try to use the functions that are recommended in the documentation but I'll run into errors with that too. Can anyone spot the issue?

INCLUDES( StageName, "Final Proposal", OR( ISBLANK( Geography__c ), ISBLANK( Languages__c ), ISBLANK( Customer_Base__c ), ISBLANK( Number_of_Agents__c ), ISBLANK( Additional_Resources_Required__c ), ISBLANK( Program_Length_In_Months__c ), ISPICKVAL( CRM_List_Requirements__c , 'N3 Provides'), ISPICKVAL( CRM_List_Requirements__c , 'Client Provided '), ISPICKVAL( Proposed_Commitments__c, 'KPI' ), ISPICKVAL( Proposed_Commitments__c, 'Metrics' ), ISPICKVAL( Proposed_Commitments__c, 'Results' ), ISBLANK( Non_Standard_Program__c ) ))

INCLUDES( StageName, "Final Proposal",
OR(
ISBLANK( Geography__c ),
ISBLANK( Languages__c ),
ISBLANK( Customer_Base__c ),
ISBLANK( Number_of_Agents__c ),
ISBLANK( Additional_Resources_Required__c ),
ISBLANK(  Program_Length_In_Months__c  ),
ISPICKVAL(  CRM_List_Requirements__c , 'N3 Provides'),
ISPICKVAL(  CRM_List_Requirements__c , 'Client Provided '),
ISPICKVAL(  Proposed_Commitments__c, 'KPI' ),
ISPICKVAL(  Proposed_Commitments__c, 'Metrics' ),
ISPICKVAL(  Proposed_Commitments__c, 'Results' ),
ISBLANK(  Non_Standard_Program__c  )
))

been going around on this. Can anybody spot whats the issue? I'm just trying to get a validation rule to work. Basically, if someone select a certain option in a picklist, I want to make sure that all the fields are populated.

I've tried a couple ways but I've gotten snagged on the 'Error: Field StageName is a picklist field. Picklist fields are only supported in certain functions.' I'll try to use the functions that are recommended in the documentation but I'll run into errors with that too. Can anyone spot the issue?

INCLUDES( StageName, "Final Proposal", OR( ISBLANK( Geography__c ), ISBLANK( Languages__c ), ISBLANK( Customer_Base__c ), ISBLANK( Number_of_Agents__c ), ISBLANK( Additional_Resources_Required__c ), ISBLANK( Program_Length_In_Months__c ), ISPICKVAL( CRM_List_Requirements__c , 'N3 Provides'), ISPICKVAL( CRM_List_Requirements__c , 'Client Provided '), ISPICKVAL( Proposed_Commitments__c, 'KPI' ), ISPICKVAL( Proposed_Commitments__c, 'Metrics' ), ISPICKVAL( Proposed_Commitments__c, 'Results' ), ISBLANK( Non_Standard_Program__c ) ))

been going around on this. Can anybody spot whats the issue? I'm just trying to get a validation rule to work. Basically, if someone select a certain option in a picklist, I want to make sure that all the fields are populated.

I've tried a couple ways but I've gotten snagged on the Error: Field StageName is a picklist field. Picklist fields are only supported in certain functions. I'll try to use the functions that are recommended in the documentation but I'll run into errors with that too. Can anyone spot the issue?

INCLUDES( StageName, "Final Proposal",
OR(
ISBLANK( Geography__c ),
ISBLANK( Languages__c ),
ISBLANK( Customer_Base__c ),
ISBLANK( Number_of_Agents__c ),
ISBLANK( Additional_Resources_Required__c ),
ISBLANK(  Program_Length_In_Months__c  ),
ISPICKVAL(  CRM_List_Requirements__c , 'N3 Provides'),
ISPICKVAL(  CRM_List_Requirements__c , 'Client Provided '),
ISPICKVAL(  Proposed_Commitments__c, 'KPI' ),
ISPICKVAL(  Proposed_Commitments__c, 'Metrics' ),
ISPICKVAL(  Proposed_Commitments__c, 'Results' ),
ISBLANK(  Non_Standard_Program__c  )
))
Source Link
Christian
  • 537
  • 1
  • 7
  • 19

Validation Rule Issue

been going around on this. Can anybody spot whats the issue? I'm just trying to get a validation rule to work. Basically, if someone select a certain option in a picklist, I want to make sure that all the fields are populated.

I've tried a couple ways but I've gotten snagged on the 'Error: Field StageName is a picklist field. Picklist fields are only supported in certain functions.' I'll try to use the functions that are recommended in the documentation but I'll run into errors with that too. Can anyone spot the issue?

INCLUDES( StageName, "Final Proposal", OR( ISBLANK( Geography__c ), ISBLANK( Languages__c ), ISBLANK( Customer_Base__c ), ISBLANK( Number_of_Agents__c ), ISBLANK( Additional_Resources_Required__c ), ISBLANK( Program_Length_In_Months__c ), ISPICKVAL( CRM_List_Requirements__c , 'N3 Provides'), ISPICKVAL( CRM_List_Requirements__c , 'Client Provided '), ISPICKVAL( Proposed_Commitments__c, 'KPI' ), ISPICKVAL( Proposed_Commitments__c, 'Metrics' ), ISPICKVAL( Proposed_Commitments__c, 'Results' ), ISBLANK( Non_Standard_Program__c ) ))