locked
Calculated Column Formula RRS feed

  • Question

  • I am using OOBSS 2010.

    I'm trying to create a calculated formula which will change the status of an item as multiple dates are entered in multiple columns.

    Specifically, the item status should be 'New' when the item is created.

    The status should change to 'Sent' when a date is entered into the "Letter Sent Date' column.

    The status should change to 'Hearing' when a date is enterd into the 'Hearing Date' column. (The 'Letter Sent Date' column will continue to have a date.)

    The status should change to 'Dealer Board' when a date is entered into the 'Board Case Date' column. (The 'Letter Sent Date' column and 'Hearing Date' column will continue to have a date.)

    The status should change to 'Closed' when a date is entered into the 'Closed Date' column. ((The 'Letter Sent Date' column, 'Hearing Date' column, and 'Dealer Board' column will continue to have a date.)

    Thank you for any assistance you can provide.

    Friday, November 7, 2014 8:56 PM

Answers

  • =if([closed date] <> "", "Closed", IF([board case date] <> "", "dealer board", if([hearing date] <> "", "hearing", "unknown")))

    Scott Brickey
    MCTS, MCPD, MCITP
    www.sbrickey.com
    Strategic Data Systems - for all your SharePoint needs

    • Marked as answer by movienut84 Monday, November 10, 2014 1:28 PM
    Friday, November 7, 2014 9:52 PM

All replies