7 Replies Latest reply: Feb 16, 2017 8:26 AM by PAUL YEO RSS

    How to make my year field easy maintenance ?

    PAUL YEO

      Hi All

       

       

      My Year field , i need to add below script :-

       

       

      =IF(year='2013','13',

      IF(year= '2014' ,'14',

      IF(year= '2015' ,'15',

      IF(year= '2016' ,'16',

      IF(year= '2017' ,'17',

      IF(year= '2000' ,'00',

      IF(year= '2001' ,'01',

      IF(year= '2002' ,'02',

      IF(year= '2003' ,'03',

      IF(year= '2004' ,'04',

      IF(year= '2005' ,'05',

      IF(year= '2006' ,'06',

      IF(year= '2007' ,'07',

      IF(year= '2008' ,'08',

      IF(year= '2009' ,'09',

      IF(year= '2011' ,'11',

      IF(year= '2012' ,'12',

       

       

      IF(year= '2010','10'))))))))))))))))))

       

       

      My issue is every year i need to amend/edit the above script by add =if(year='2018','18',

       

       

      it there any way i can make it automatic ? Dont need edit the script yearly ?

       

       

      Paul