답변 13개
You'll do this with 3 steps:
1) create a custom Date field to capture the date of the most recent Stage change.
2) create a Workflow Rule Field Update that runs on 'every edit' when ISCHANGED(StageName) and sets the custom Date field from #1 above to TODAY()
3) create a custom formula text field to display your flag:
IF( TODAY() - dateStageChanged__c > 14,
IMAGE ( "/img/samples/flag_red.gif","Red"),
IF( TODAY() - dateStageChanged__c > 6,
IMAGE("/img/samples/flag_yellow.gif","Yellow"),
IMAGE ( "/img/samples/flag_green.gif","Green"))
)
