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
Best Answer

Did you ever have one of those ahha moments?!! Well I just did. I didn't name the column correctly in my calculation. Now it works. Thanks for the help though.
Answers

Hi Liz,
Try this and let me know if it works.
=if([Configuration]@row=90,[Belt Length Tier]@row*0.25,0)
The above IF statement translates to: If the configuration on this row is equal to 90, multiply the Belt Length Tier on this row times 0.25. Otherwise, display 0.
Thanks,
Heather

I'm sorry but that doesn't work. It is exactly as I had it. Like I mentioned above, even the "yes","no" isn't working either for the true/false response

Can you please provide a screenshot (with private information blocked out)? This may help figure things out.

Did you ever have one of those ahha moments?!! Well I just did. I didn't name the column correctly in my calculation. Now it works. Thanks for the help though.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 406 Global Discussions
 218 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!