Ask
ShowAll Questionssorted byDate Posted
Kelly Bentubo

# Formula help override date

We are trying to create a formula that will either calcuate a date or use a date entered by a user into a field we are calling &quot;Date Override&quot;. For example, we normally delivery products in 10 weeks but the supply chain wants to override that on occasion when its a special order. We have tried to use nested if formulas but we get an error about not being able to directly or indirectly reference the field in the formula.<br /> <br /> This is the formula to calculate the date field: <table class="detailList" cellspacing="0" cellpadding="0" border="0"> <tbody> <tr class="detailRow last"> <td colspan="4">IF( CloseDate &lt; Customer_Requested_Delivery_Date__c , CRDD_SCCD__c , ECD_SCCD__c )</td> </tr> </tbody> </table> <br /> <div class="pbFooter secondaryPalette"> <div class="bg"><br /> We would like to include the override date field in the formula something like this:<br /> <div class="pbFooter secondaryPalette"> <div class="bg"> <div class="pbFooter secondaryPalette"> <div class="bg"> <table class="detailList" cellspacing="0" cellpadding="0" border="0"> <tbody> <tr class="detailRow last"> <td colspan="4">IF( CloseDate &lt; Customer_Requested_Delivery_Date__c , CRDD_SCCD__c , ECD_SCCD__c , IF(override&nbsp; is populated use override date otherwise use previous formula))<br /> <br /> Obviously the second formula is pseudo-code but provides the essence of what we want to accomplish.</td> </tr> </tbody> </table> <div class="pbFooter secondaryPalette"> <div class="bg">&nbsp;</div> </div> <!-- Body events --> <script type="text/javascript"> function bodyOnLoad() { setFocusOnLoad(); if (typeof(startSessionTimer)!='undefined') {startSessionTimer(); }; SetupTreeNode.prototype.initializeSetup(); HTMLTreeNode.prototype.populateTheTreeInformation('_font','_child','_icon','_leaf','Expand','Collapse','/img/alohaSkin/setup/setup_plus_lev1.gif','/img/alohaSkin/setup/setup_minus_lev1.gif','setupHighlightLeaf','setupLeaf'); if ((window.sfdcPage) && (sfdcPage.executeOnloadQueue)){sfdcPage.executeOnloadQueue();}; } function bodyOnBeforeUnload() { if ((window.sfdcPage) && (sfdcPage.executeOnBeforeUnloadQueue)){sfdcPage.executeOnBeforeUnloadQueue();}; } function bodyOnFocus() { closePopup(); } function bodyOnUnload() { } </script> <!-- End page content --></div> </div> <!-- Body events --> <script type="text/javascript"> function bodyOnLoad() { setFocusOnLoad(); if (typeof(startSessionTimer)!='undefined') {startSessionTimer(); }; SetupTreeNode.prototype.initializeSetup(); HTMLTreeNode.prototype.populateTheTreeInformation('_font','_child','_icon','_leaf','Expand','Collapse','/img/alohaSkin/setup/setup_plus_lev1.gif','/img/alohaSkin/setup/setup_minus_lev1.gif','setupHighlightLeaf','setupLeaf'); if ((window.sfdcPage) && (sfdcPage.executeOnloadQueue)){sfdcPage.executeOnloadQueue();}; } function bodyOnBeforeUnload() { if ((window.sfdcPage) && (sfdcPage.executeOnBeforeUnloadQueue)){sfdcPage.executeOnBeforeUnloadQueue();}; } function bodyOnFocus() { closePopup(); } function bodyOnUnload() { } </script> <!-- End page content --></div> </div> <!-- Body events --> <script type="text/javascript"> function bodyOnLoad() { setFocusOnLoad(); if (typeof(startSessionTimer)!='undefined') {startSessionTimer(); }; SetupTreeNode.prototype.initializeSetup(); HTMLTreeNode.prototype.populateTheTreeInformation('_font','_child','_icon','_leaf','Expand','Collapse','/img/alohaSkin/setup/setup_plus_lev1.gif','/img/alohaSkin/setup/setup_minus_lev1.gif','setupHighlightLeaf','setupLeaf'); if ((window.sfdcPage) && (sfdcPage.executeOnloadQueue)){sfdcPage.executeOnloadQueue();}; } function bodyOnBeforeUnload() { if ((window.sfdcPage) && (sfdcPage.executeOnBeforeUnloadQueue)){sfdcPage.executeOnBeforeUnloadQueue();}; } function bodyOnFocus() { closePopup(); } function bodyOnUnload() { } </script> <!-- End page content --></div> </div> <!-- Body events --> <script type="text/javascript"> function bodyOnLoad() { setFocusOnLoad(); if (typeof(startSessionTimer)!='undefined') {startSessionTimer(); }; SetupTreeNode.prototype.initializeSetup(); HTMLTreeNode.prototype.populateTheTreeInformation('_font','_child','_icon','_leaf','Expand','Collapse','/img/alohaSkin/setup/setup_plus_lev1.gif','/img/alohaSkin/setup/setup_minus_lev1.gif','setupHighlightLeaf','setupLeaf'); if ((window.sfdcPage) && (sfdcPage.executeOnloadQueue)){sfdcPage.executeOnloadQueue();}; } function bodyOnBeforeUnload() { if ((window.sfdcPage) && (sfdcPage.executeOnBeforeUnloadQueue)){sfdcPage.executeOnBeforeUnloadQueue();}; } function bodyOnFocus() { closePopup(); } function bodyOnUnload() { } </script> <!-- End page content -->
Kelly Bentubo
We are trying to create a formula that will either calcuate a date or use a date entered by a user into a field we are calling &quot;Date Override&quot;. For example, we normally delivery products in 10 weeks but the supply chain wants to override that on occasion when its a special order. We have tried to use nested if formulas but we get an error about not being able to directly or indirectly reference the field in the formula.<br /> <br /> This is the formula to calculate the date field:

IF( CloseDate < Customer_Requested_Delivery_Date__c , CRDD_SCCD__c , ECD_SCCD__c )

We would like to include the override date field in the formula something like this
IF( CloseDate < Customer_Requested_Delivery_Date__c , CRDD_SCCD__c , ECD_SCCD__c )IF(override; is populated use override date otherwise use previous formula))

Obviously the second formula is pseudo-code but provides the essence of what we want to accomplish.

Tom Thomas
overide create data on data import