You need to sign in to do that
Don't have an account?
Leah Morgan
Auto Fill Case Complete Time
Hello,
I'm trying to set up a simple formula for my org that will autopopulate the case complete time when it is switched into a completed or closed status, otherwise it will put N/A in the field. If the case is switched from completed to closed, I don't want it to update again, but if it's switched from any other value, to completed or closed, I want it to overwrite the 'N/A' and put in the closed/completed time.
This is what I have so far, (I could be way off...) but the formula editor is giving me an error, would anyone be willing to take a look at it and let me know what I did wrong? Thank you!
I'm trying to set up a simple formula for my org that will autopopulate the case complete time when it is switched into a completed or closed status, otherwise it will put N/A in the field. If the case is switched from completed to closed, I don't want it to update again, but if it's switched from any other value, to completed or closed, I want it to overwrite the 'N/A' and put in the closed/completed time.
This is what I have so far, (I could be way off...) but the formula editor is giving me an error, would anyone be willing to take a look at it and let me know what I did wrong? Thank you!
If (AND((ISPICKVAL(Status = "Complete")||(ISPICKVAL(Status = "Closed"), ISBLANK(Complete_Date_Time) || (Complete_Date_Time = "N/A"), NOW(), BLANKVALUE(Complete_Date_Time, "N/A"))
All Answers
Please try below formula.
Hope this will solve your problem, let me know if you still face issues in this.
Thanks,
Gaurav
Email: gauravgarg.nmim@gmail.com
If (
OR(
ISPICKVAL(Status, 'Complete'),
ISPICKVAL(Status, 'Closed')
),
TEXT(NOW()),
"N/A"
)
Please try this:
Let me know if you still face issues on this.
Thanks,
Gaurav