I can get this to work with the following code, i just don't know how to test the isnull or isblank condition as i get a circular reference error.
IF(s2_Stage_1_Complete__c, today()+45, NULL)
s2_Stage_1_Complete__c is the checkbox
s2_Stage_2_Complete__c is the formula field
the other option is to have the formula field update a third field, this works but it updates the formula field and not the newfield__c
IF(s2_Stage_1_Complete__c=TRUE, IF (ISBLANK(newfield_c),today()+45',""),"")
Note: we are using pro so no workflow option.
10 respuestas
My work around is to make Stage_1_complete a date field instead, the formula field will populate Stage_2_complete based on date chosen in Stage_1_complete and add 45 days. Since Stage_1_complete never changes once chosen, Stage_2_complete will never change.
And so on with stage 3, 4 and 5.
