0

Show date when # turns < than #

I have a formula that turns yellow when stock is low, and red when we need to re-order. I'd like to show the date that happens as we don't always see it as soon as it happens. Is this possible? The current formula:

 

let AA := sum('Seamless QTY on Hand (Bags)') + sum('HELP QTY on Hand (Bags)') + sum('Mt Waverley QTY on Hand (Bags)');
styled(text(AA), if AA < sum('Re-Order Level (bags)') then
"red"
else
if AA > sum('Re-Order Level (bags)') and AA < sum('Low Stock Level') then
"yellow"
else
"#dfdfdf"
end
end)

1 reply

null
    • Sean
    • 5 yrs ago
    • Reported - view

    Hi Sarah,

     

    You would need to add a status date field that would be updated based on a trigger and then you could do something like this...

     

    let AA := sum('Seamless QTY on Hand (Bags)') + sum('HELP QTY on Hand (Bags)') + sum('Mt Waverley QTY on Hand (Bags)');
    styled(if AA > sum('Low Stock Level') then
    text(AA)
    else
    text(AA) + " - " + 'Status Date'
    end, if AA < sum('Re-Order Level (bags)') then
    "red"
    else
    if AA > sum('Re-Order Level (bags)') and AA < sum('Low Stock Level') then
    "yellow"
    else
    "#dfdfdf"
    end
    end)

Login to reply

Content aside

  • 5 yrs agoLast active
  • 1Replies
  • 859Views