I am trying to use Process Builder to workflow an Email...
Initially i used a formula to calculate the percentage complete from today:
IF(Course_Start_Date__c > TODAY(),0, IF(Course_End_Date__c < TODAY(),1,( TODAY() - Course_Start_Date__c) /(Course_End_Date__c - Course_Start_Date__c)))
I was reminded that formulas are calculated on the fly, it couldn't be used to trigger a Workflow, or Process Builder.
I have tried to enter the formula into the Process builder as well:
(whenever a record is created or edited)
Build Formula =
(TODAY() - [object__c].Course_Start_Date__c)/ ([object__c].Course_End_Date__c - [object__c].Course_Start_Date__c) > 79
To update a checkbox to be true
Send_Email__c, this isn't updating the field either.