Can anyone help with this formula?
It works in excel but I am getting Unparseable error in smartsheets.
=IFERROR(IF([QTY]@row,<>0,[QTY]@row*[Production Rate]@row),IF([Linear Feet]@row<>0,[Linear Feet]@row/[Production Rate]@row,[Sqft]@row/[Production Rate]@row)),0)
Thanks for any help