Skip to main content
Topics#Data ManagementDave Meixell's Question
Dave Meixell (Partner Tech) asked in #Data Management
Apr 20, 2019, 6:37 PM

Need help with a formula.

I want to calulate the number of days outstanding from todays date to "Start Date" based on if one of the following two values (Shipped or Support Issues)  is selected from a picklist.  How would I wirte the formula?
5 answers
  1. sakshi nagpal (LTIMindtree Ltd)
    Apr 20, 2019, 7:43 PM
    Hi Dave,

     

    I added "No" to your formula,

     

    IF(

     

    OR(

     

    ISPICKVAL( ForecastCategoryName , 'Certified')

     

    ,ISPICKVAL(ForecastCategoryName, 'Purchased')

     

    ,ISPICKVAL(ForecastCategoryName, 'Returned')

     

    ), "Yes","No")

     

     There are three parameters in If

     

    1)logical condition-

     

    OR(

     

    ISPICKVAL( ForecastCategoryName , 'Certified')

     

    ,ISPICKVAL(ForecastCategoryName, 'Purchased')

     

    ,ISPICKVAL(ForecastCategoryName, 'Returned')

     

    2)value if logical condition is true-"Yes"

     

    3)value if logical condition is false-"No"

     

     3rd parameter was missing in your formula

     

     
Write an answer...
0/9000