function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Dean NewcombeDean Newcombe 

Validation Rules - another question!

Sorry experts, I am still having some issues with basic formulas. If you could please assist with these two, I would truly appreciate it.

1. When 'Ready_Set_Go_Pack_Printed__c' (date field) OR when 'Stage' = 'RSG Sent' 'Booking_Confirmed__c' (checkbox) becomes mandatory.
 
2. When Stage = 'Fundraising Phase',  'Have_Confirmed_Materials_Are_Out__c' (date) becomes mandatory.

I'm working through a range of different formulas, so I'm hoping with these two examples, I'll be able to work it from there.

Thank you so much in advance!
Best Answer chosen by Dean Newcombe
Maharajan CMaharajan C
Try the below Formula:
  
OR( 
NOT(ISNULL(Actual_Install_Date__c)), 
ISPICKVAL(Lead_Sources_for_Career_Advisor__c, 'RSG Sent'),
Booking_Confirmed__c <> TRUE
)

if the above formula is not working then please elaborate the 1st requirement further.

Thanks,
Maharajan.C

All Answers

Dean NewcombeDean Newcombe
I've been able to get the 2nd one to work:
'2. When Stage = 'Fundraising Phase',  'Have_Confirmed_Materials_Are_Out__c' (date) becomes mandatory.'

However still unfortunately cannot get the first to work. Any advice would be truly appreciated. 
Maharajan CMaharajan C
Try the below Formula:
  
OR( 
NOT(ISNULL(Actual_Install_Date__c)), 
ISPICKVAL(Lead_Sources_for_Career_Advisor__c, 'RSG Sent'),
Booking_Confirmed__c <> TRUE
)

if the above formula is not working then please elaborate the 1st requirement further.

Thanks,
Maharajan.C
This was selected as the best answer
Dean NewcombeDean Newcombe
Thank you Maharajan, that worked perfectly.