I have a formula field which is a check box that automatically is ticked/not ticked depending on the formula criteria. This formula field works perfectly for me.
Although i have various workflows which i am trying to set-up which are based upon the result of this formula field. I have tried various aspects for getting this to work but cannot seem to fix this, has anyone any suggestions?
Currently my workflow criteria is:
ISPICKVAL(Active_Client_c,"Yes") && Formula_Field_c <> null
I have looked for previous questions but none of the solutions seem to work for me as there is no manual interaction from anyone to change the Formula_Field as its automatic. The current method only works when someone has edited/modified the record in question but I need this to work automatically even if a record has not been edited. Any help is greatly appreciated.