Post

1 follower Follow
0
Avatar

Updating a formula field with a Custom Action

I have a Custom Field, which is a formula field.  I can't remove the formula aspect of the field to make a switch to updating via workflow rule and the field is too integral to our processes and project structure to easily replace it with a non-formula equivalent (it's displayed or filtered in 90-some% of our reports and workflow rules).

So instead, to try and avoid all that surgery, I want to start updating the formula field with a Custom Action (we have one already that updates the Task that the formula field is tied to) because the formula seems to be unreliable (sometimes it updates immediately, other times it never gets around to updating). 

 

Is there any reason *not* to use a business rule (CA or WFR) to update a formula field?  I understand that the formula, when it does get around to calculating, would override the dropped-in value but it should just be the same value that was dropped in anyway.

I'm just looking for any "I did that and my whole environment caught fire" cautionary tales before I pull the trigger on this.

Richard Mann Answered

Please sign in to leave a comment.

1 comment

0
Avatar

Nevermind, Formula fields are not on the list of available project fields to update.

Richard Mann 0 votes
Comment actions Permalink