I'm trying to create a date formula field that updates with the date that the Status field is changed, but only when it is changed to one of 3 picklist values, all of which begin with AGR. This is on a custom object. So far I have tried this: ISCHANGED(( Status__c ), BEGINS(TEXT(ISPICKVAL( Status__c, "AGR"),TODAY()))) Which gives me the error message - Error: Incorrect number of parameters for function 'TEXT()'. Expected 1, received 2 And this (slightly different parenthesis): ISCHANGED(( Status__c ), BEGINS(TEXT(ISPICKVAL( Status__c, "AGR")),TODAY())) Which gives me the error message - Error: Incorrect parameter type for function 'TEXT()'. Expected Number, Date, Date/Time, Picklist, received Boolean And this (removing TEXT): ISCHANGED(( Status__c ), BEGINS(ISPICKVAL( Status__c, "AGR"),TODAY())) Which gives me the error message - Error: Incorrect parameter type for function 'BEGINS()'. Expected Text, received Boolean Any tips please?
6 answers
