Skip to main content
CASE (SLS__c, "AOG 4h", CreatedDate, "Critical 4h to 24h", CreatedDate + 1, "Routine 30 Days", CreatedDate + 29, "Special Project", NULL)
2 answers
  1. Jun 13, 2012, 6:35 PM
    Beacause you have multiple fields in your CASE statement.

     

    CASE functions work like this:

     

    CASE(TheField,

     

    "The Field Value 1", Result 1,

     

    "The Field Value 2", Result 2,

     

    "The Field Value 3", Result 3,

     

    NULL)

     

    your formula is doing something like:

     

    CASE(TheField,

     

    "The Field Value 1", Result 1,

     

    "The Field Value 2", Do another formula ,

     

    "The Field Value 3", Do another formula ,

     

    NULL)
0/9000