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 ah-ha 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 ah-ha 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!