If Statement just not working

i'm struggling with the if statement in general. I have the following set up in my sheet

Configuration Column - drop down to allow 4 choices (90, 180, 270, 360)

Overall Length - needs to take choice from drop down and have a formula apply depending on the answer (formula applied is using a result from another calculated column - Belt Length Tier)

Belt Length Tier - calculated field

I've tried to just simplify the formula and only have it look for 1 choice and can't get the if statement to work.

this is what i have so far:

=if[Configuration]@row=90,[Belt Length Tier]*0.25,0

on its own [Belt Length Tier]*0.25 formula works, but as soon as I par it with the if formula I receive the dreaded #UNPARSEABLE

I even tried just trying out the if statement with a real easy result, with total failure.

=if[Configuration]@row=90,"YES","NO"

I have moved parentheses around so much, I'm not even sure that is my problem.

Thanks for the help

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!