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))))
