I am struggling with this validation rule, and I cannot figure out why.
Submission is a currency field and Submission Comment is a text field.
I want to throw an error when someone enters a submission value (be it positive or negative), but does not have a comment entered. The above validation rule should be giving me this result (at least in my mind), but the record is still saving if I add a submission and leave the comment field blank. It also saves if I fill in something in the comment field.
Any help on this would be much appreciated.
Here is what I am doing with this. I have a long text area that will be used to track history of these 2 fields. Whenever someone enters a submission, I have a rule that will take the submission value, and add it to a rolling total field. We have been using the normal field history until now. But, recently, we have had an increase in the number of customers asking why their submissions are higher than expected. Instead of people having to look back through emails and other correspondence over the past year, the new comment field will allow us to track notes and comments about the submission so that we don't have to spend as much time researching these requests. Nothing has been entered incorrectly so far, so our normal process is working great. I just need to reduce the research time that has increased over the past few months.