You need to sign in to do that
Don't have an account?
carmyke
Need help with creating a formula that will auto-populate Revenue Quarter and Booking Quarter
I have created a custom field called Booking Quarter (Booking Qtr) and I want to auto populate this field with a specific fiscal quarter. For example, when my sales team enters Close Date of 6/15/2010, I want the Booking Qtr field to auto-populate with Q2 2010. Any advice on how to do this? Our fiscal quarters align with calendar quarters (i.e. CY Q1 = FY Q1).
Thank you.
Hey Carmyke,
Here is a formula that you can use. (Assuming your close date field is custom - otherwise replace it with the actual field name). You need to put this formula under your Booking Quarter field. Let me know if you have any questions.
CASE(
MONTH(Close_Date__c),
1, "CY Q1" + "-" + TEXT(YEAR(Close_Date__c)),
2, "CY Q1"+ "-" + TEXT(YEAR(Close_Date__c)),
3, "CY Q1"+ "-" + TEXT(YEAR(Close_Date__c)),
4, "CY Q2"+ "-" + TEXT(YEAR(Close_Date__c)),
5, "CY Q2"+ "-" + TEXT(YEAR(Close_Date__c)),
6, "CY Q2"+ "-" + TEXT(YEAR(Close_Date__c)),
7, "CY Q3"+ "-" + TEXT(YEAR(Close_Date__c)),
8, "CY Q3"+ "-" + TEXT(YEAR(Close_Date__c)),
9, "CY Q3"+ "-" + TEXT(YEAR(Close_Date__c)),
10, "CY Q4"+ "-" + TEXT(YEAR(Close_Date__c)),
11, "CY Q4"+ "-" + TEXT(YEAR(Close_Date__c)),
12, "CY Q4"+ "-" + TEXT(YEAR(Close_Date__c)),
"Error")
Thanks!
All Answers
Hey Carmyke,
Here is a formula that you can use. (Assuming your close date field is custom - otherwise replace it with the actual field name). You need to put this formula under your Booking Quarter field. Let me know if you have any questions.
CASE(
MONTH(Close_Date__c),
1, "CY Q1" + "-" + TEXT(YEAR(Close_Date__c)),
2, "CY Q1"+ "-" + TEXT(YEAR(Close_Date__c)),
3, "CY Q1"+ "-" + TEXT(YEAR(Close_Date__c)),
4, "CY Q2"+ "-" + TEXT(YEAR(Close_Date__c)),
5, "CY Q2"+ "-" + TEXT(YEAR(Close_Date__c)),
6, "CY Q2"+ "-" + TEXT(YEAR(Close_Date__c)),
7, "CY Q3"+ "-" + TEXT(YEAR(Close_Date__c)),
8, "CY Q3"+ "-" + TEXT(YEAR(Close_Date__c)),
9, "CY Q3"+ "-" + TEXT(YEAR(Close_Date__c)),
10, "CY Q4"+ "-" + TEXT(YEAR(Close_Date__c)),
11, "CY Q4"+ "-" + TEXT(YEAR(Close_Date__c)),
12, "CY Q4"+ "-" + TEXT(YEAR(Close_Date__c)),
"Error")
Thanks!
King Kong!! You are AWESOME!! Exactly what I needed. Worked perfectly.
Sincere thanks,
Sean