How can I send a notification based on a formula field?
I am trying to send an email when a field is below a certain percentage. I have tried when below 85 or 85% but it isn't working. The field is a formula field.
Forum Discussion
Does the Percentage change as a result of that record being edited? Notifications are evaluated to fire or not fire at the moment the record is saved. They do not fire as a result of changes to other records.
BUT, perhaps this is a straight forward edit to a record and it's not firing. The firing should be based on a field being less than .85 and not when its less than 85. A percentage field is actually a number typically less than 1, such as 85% is really 0.85.
BUT, perhaps this is a straight forward edit to a record and it's not firing. The firing should be based on a field being less than .85 and not when its less than 85. A percentage field is actually a number typically less than 1, such as 85% is really 0.85.