Skip to main content

I have a base that I use to manage our shipping materials. The "Material's On Hand" is calculated by a formula. I would like to have the option to override this formula if I enter data in a form. The override field is titled "Cycle Count Override". I am currently using the below formula but as you can see from the screenshot it is unsuccesful.

 

IF({Cycle Count Override}, {Cycle Count Override}, {Material's Received}-{Material's used Rollup (from Outbound)})

Try this route instead using Length, I don't think what you currently have will work as there is nothing to say if it is true or false. 

IF(
LEN({Cycle Count Override}) = 0,
{Materials Received} - {Materials used Rollup (from Outbound)},
{Cycle Count Override}
)

Reply


Terms & Conditions