0 Replies Latest reply: Feb 8, 2018 8:04 AM by Simon McCoy RSS

    Backround formatting

    Simon McCoy

      Hi, I have an app here that I upload a usage limit to every day my expression picks the most recent date but im trying to format the column to show colours around the status of inventory.. so with the code below I get the output I require when I select the most recent date but im looking for the page to open and this formatting to be applied to the most recent date. So im wondering how I could build

      {<[Value Date]={"$(=Date(Max([Value Date])))"}>} into the below If statement. If anyone has any ideas it would be great

      Thanks

       

      IF([Stock.Status]='FAIL',RGB(255,0,0),

      IF([Stock.Status]='PASS',RGB(0,200,0),

      IF([Stock.Status]='WARN',RGB(255,255,0))))