We have the field Performance Increase which we manually enter a $$ figure in for eligible staff. If this field has a value in it, I would like another field to display the message "Increase based on previous performance". If the Performance Increase field is blank, this new formula field should also be blank.
I tried using IF(NOT(ISBLANK(Performance increase, "Message",""))) but received errors. Formulas are not my forte :|
Is someone able to tell me where I've gone wrong (and why you did it the way you did would be greatly appreciated!)
Cheers
Rob
16 answers
Hi Rob,
You have the right idea, we just need to fix the syntax. Let's try:
IF(ISBLANK(Performance_increase__c), null, "Message")
