I am trying to convert this formula: IF({Quantity}>={Item Minimum}, “Not Notified”, IF(DIVIDE({Item Minimum},2)<{Quantity},“Needs to be Notified”, “Important Notification”))
into a general caster formula but I am unable to get it to work. The general caster formula I currently have is: IF({item’s Quantity}>={item’s Item Minimum}, “Not Notified”, IF(DIVIDE({item’s Item Minimum} / 2)<{item’s Quantity}, “Needs To Be Notified”, “Important Notification”))
My current General Caster Formula is using when column changes perform formula and output to column. It runs whenever the quantity changes and it is casting the result to a status column with Needs to be Notified, Not Notified, and Important Notification as the status’. The problem is that the general caster formula only ever outputs Not Notified or Needs to be Notified. I want it to check if quantity is less than the minimum then check if quantity is less than half the minimum. If quantity is less than the minimum but higher than half the minimum than it should output needs to be notified. If the quantity is less than the minimum and less than half the minimum than it should output important notification. If someone could point out where I am making a mistake in my formula or offer a different formula as a solution I would greatly appreciate it.