Help to create this field, i am not user how to write the conditions.
CourseFlag__c = Y,N
If ANY of the following fields are blank put as Y
Course Name, Course Category, Durations mths, Sales 1,Sales 2, Sales 3
답변 2개
You would need to write something like this:
IF(OR(
ISBLANK(Course_Name__c),
ISBLANK(Course_Category__c),
ISBLANK(Duration_mths__c),
etc...
ISBLANK(Sales_3__c)), True, False)
The formula says to check if any of the listed fields are blank, then return True, otherwise return False. Note that depending on what data type your fields are, ISBLANK may not work, you may have to modify. Also, be sure to use the API names of all your fields, I just took a guess and may be wrong with what they are called in your system exactly.
