Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

I can add/subtract, but multiply/divide gives error

790 1
cancel
Showing results for 
Search instead for 
Did you mean: 
philraymond
5 - Automation Enthusiast
5 - Automation Enthusiast

Is it a bug? My formula works when I do +1.

But when I do *1 I get all errors:

Screen Shot 2023-01-14 at 12.17.25 PM.png

 

1 Reply 1
philraymond
5 - Automation Enthusiast
5 - Automation Enthusiast

I figured it out. It is kind of a bug, but also my mistake.

The field the formula is referencing contains an IF statement. When that IF statement is true, there's a formula. When the IF statement is false, I had put apostrophe apostrophe ('') in an attempt to leave those cells blank. Back to the field that's throwing all errors, it was interpreting the other field as text, so throwing all the errors. But as for why the addition worked and not the multiplication, that's weird.

Anyway, the solution for that other field was just to have nothing for the false IF statement, like this:

IF({Plantings}>1,{Units} * {Weeks})