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
Kim StitesKim Stites 

week of a quarter formula

I am trying to create a formula that gives me the week of a given quarter.  I had OR for all weeks but that gave me an error and then removing the OR gave me another error.  Can anyone help me with this formula?

IF( Week_of_the_Year__c = (1,15,30,43),1,
IF( Week_of_the_Year__c = OR(2,16,31,44),2,
IF( Week_of_the_Year__c = OR(3,17,32,45),3,
IF( Week_of_the_Year__c = OR(4,18,33,46),4,
IF( Week_of_the_Year__c = OR(5,19,34,47),5,
IF( Week_of_the_Year__c = OR(6,20,35,48),6,
IF( Week_of_the_Year__c = OR(7,21,36,49),7,
IF( Week_of_the_Year__c = OR(8,22,37,50),8,
IF( Week_of_the_Year__c = OR(9,23,38,51),9,
IF( Week_of_the_Year__c = OR(10,24,39,52),10,
IF( Week_of_the_Year__c = OR(11,25,40,53),11,
IF( Week_of_the_Year__c = OR(12,26,41,54),12,
IF( Week_of_the_Year__c = OR(13,27,42,55),13,
IF( Week_of_the_Year__c = OR(14,28,29,56),14,0))))))))))))))
LBKLBK
Hi Kim,

Try this formula instead. 
IF( 
OR(Week_of_the_Year__c = 1,Week_of_the_Year__c = 15,Week_of_the_Year__c = 30,Week_of_the_Year__c = 43),1,
IF(
OR(Week_of_the_Year__c = 2,Week_of_the_Year__c = 16,Week_of_the_Year__c = 31,Week_of_the_Year__c = 44),2,
IF(
OR(Week_of_the_Year__c = 3,Week_of_the_Year__c = 17,Week_of_the_Year__c = 32,Week_of_the_Year__c = 45),3,
IF(
OR(Week_of_the_Year__c = 4,Week_of_the_Year__c = 18,Week_of_the_Year__c = 33,Week_of_the_Year__c = 46),4,
IF(
OR(Week_of_the_Year__c = 5,Week_of_the_Year__c = 19,Week_of_the_Year__c = 34,Week_of_the_Year__c = 47),5,
IF(
OR(Week_of_the_Year__c = 6,Week_of_the_Year__c = 20,Week_of_the_Year__c = 35,Week_of_the_Year__c = 48),6,
IF(
OR(Week_of_the_Year__c = 7,Week_of_the_Year__c = 21,Week_of_the_Year__c = 36,Week_of_the_Year__c = 49),7,
IF(
OR(Week_of_the_Year__c = 8,Week_of_the_Year__c = 22,Week_of_the_Year__c = 37,Week_of_the_Year__c = 50),8,
IF(
OR(Week_of_the_Year__c = 9,Week_of_the_Year__c = 23,Week_of_the_Year__c = 38,Week_of_the_Year__c = 51),9,
IF(
OR(Week_of_the_Year__c = 10,Week_of_the_Year__c = 24,Week_of_the_Year__c = 39,Week_of_the_Year__c = 52),10,
IF(
OR(Week_of_the_Year__c = 11,Week_of_the_Year__c = 25,Week_of_the_Year__c = 40,Week_of_the_Year__c = 53),11,
IF(
OR(Week_of_the_Year__c = 12,Week_of_the_Year__c = 26,Week_of_the_Year__c = 41,Week_of_the_Year__c = 54),12,
IF(
OR(Week_of_the_Year__c = 13,Week_of_the_Year__c = 27,Week_of_the_Year__c = 42,Week_of_the_Year__c = 55),13,
IF(
OR(Week_of_the_Year__c = 14,Week_of_the_Year__c = 28,Week_of_the_Year__c = 29,Week_of_the_Year__c = 56),14,0))))))))))))))
Let me know how it goes.