+ Start a Discussion
PetyaPetya 

Formula Question

Hi, 

 

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?

AravindBabu512AravindBabu512

Hi,

 

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