+ Start a Discussion

Formula Question



I try to make a formula to check for a Multiselected Picklist Field, how long a value was selected e.g. my Picklist Value is “Problem not solved” and I want to estimate the time to the next status e.g. *Problem solved", and save this value in another field with workflow.
Any advices?




Please see if this works,


1) Create 2 fields 1-date field(Say DF) 2-number field( Say NF)

2) Initially the date field will be record created date

3) On changing the value, NF will be updated to TODAY - DF

4) On saving the record DF will be updated to TODAY