Sign Up ›
  • Sel Diesta
  • NEWBIE
  • 10 Points
  • Member since 2015
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 2
    Replies
SOLVED
4 replies

formula field to enable boolean field based on picklist

I am trying to update the field based on the following conditions:

if the Date Create is less that 30 seconds and the Lead Status = Working Contacted.
I have my formula below that does not work:

IF( OR(ISPICKVAL(Status,"Working - Contacted"))
    DATEVALUE(LastModifiedDate  - CreatedDate) * 86400<= 30)),TRUE,FALSE)

Please help.
SOLVED
4 replies

formula field to enable boolean field based on picklist

I am trying to update the field based on the following conditions:

if the Date Create is less that 30 seconds and the Lead Status = Working Contacted.
I have my formula below that does not work:

IF( OR(ISPICKVAL(Status,"Working - Contacted"))
    DATEVALUE(LastModifiedDate  - CreatedDate) * 86400<= 30)),TRUE,FALSE)

Please help.