You need to sign in to do that
Don't have an account?
nclay
"IF" Validation Rules
I'm having difficulty finding appropriate validation rule examples to build from.
- I'd like to create a validation rule indicating that if the Opportunity Stage equals Revist that the Close Date cannot exceed one year from today. Is that possible?
- I have Professional Edition so user permissions are a bit different. I would like to create another rule indicating that if you are not a system administrator you cannot delete Opportunities. Is that possible?
Any help would be greatly appreciated!
N
Hi nclay,
I tried this validation rule on my development org and it worked OK.
If ( ISPICKVAL(StageName, "Revisit" ),
If( CloseDate >= TODAY() +365, True, False),
False)
I put the message next to the Close Date and said something like: "Close Date must not be greater than one year from today."
As for your second question, I'm not familiar with Professional Edition, but I would think you could go to the user profiles, uncheck the delete box on the rights for opportunities. This would effectively keeping users from deleting opportunities.
Hope these suggestion help.
All Answers
Hi nclay,
I tried this validation rule on my development org and it worked OK.
If ( ISPICKVAL(StageName, "Revisit" ),
If( CloseDate >= TODAY() +365, True, False),
False)
I put the message next to the Close Date and said something like: "Close Date must not be greater than one year from today."
As for your second question, I'm not familiar with Professional Edition, but I would think you could go to the user profiles, uncheck the delete box on the rights for opportunities. This would effectively keeping users from deleting opportunities.
Hope these suggestion help.
Thank you so much - the validation rule worked perfectly!
Professional edition doesn't have the delete box on the rights for opportunities. I'll keep trying to work out an alternate solution for that.
Again, thank you so much for the help. Have a great day - you made mine!