Help

Override a cell that contains a formula

Topic Labels: Formulas
1089 1
cancel
Showing results for 
Search instead for 
Did you mean: 
JohnShaffer
4 - Data Explorer
4 - Data Explorer

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)})
1 Reply 1
joshsorenson
6 - Interface Innovator
6 - Interface Innovator

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