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
Gwen ONeill 9Gwen ONeill 9 

multiple statements checkbox formula

I may be asking too much from a checkbox, BUT - I'm trying to set up a checkbox that is True if someone is out of the office and is blank if they are not.  I know it's not correct, but thought it could show what I'm trying to attempt, here's what I've tried so far:

IF
(
Or

(Out_of_Office_Start__c  <=  NOW()  &&  NOW()  <= Out_of_Office_End__c,TRUE),

OR
 
(Out_of_Office_Start2__c  <=  NOW()  &&  NOW()  <=  Out_of_Office_End2__c ,TRUE),

OR   (ISBLANK(Out_of_Office_Start2__c. False))
Best Answer chosen by Gwen ONeill 9
AnkaiahAnkaiah (Salesforce Developers) 
Hi Gwen,

try with below formula. 
IF(OR(AND(Out_of_Office_Start__c  <=  NOW(),
          NOW()  <= Out_of_Office_End__c),
	  AND(Out_of_Office_Start2__c <=  NOW(),
     	  NOW()  <=  Out_of_Office_End2__c)),TRUE,FALSE)

If this helps, Please mark it as best answer.

Thanks!!​​​​​​​

All Answers

AnkaiahAnkaiah (Salesforce Developers) 
Hi Gwen,

try with below formula. 
IF(OR(AND(Out_of_Office_Start__c  <=  NOW(),
          NOW()  <= Out_of_Office_End__c),
	  AND(Out_of_Office_Start2__c <=  NOW(),
     	  NOW()  <=  Out_of_Office_End2__c)),TRUE,FALSE)

If this helps, Please mark it as best answer.

Thanks!!​​​​​​​
This was selected as the best answer
Gwen ONeill 9Gwen ONeill 9
PERFECT!  Thank you!