Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
Issues with Convert to Column Formula
Hi,
I have a column that I'm trying to convert to column formula but won't because "The column formula syntax isn't quite right" and gives me Smartsheet's help article for more information.
The column's type that I'm trying convert is "Symbols" and is the Progress Bar. The Formula of the attached example is:
=IF([RPM %]851 = 0, "Empty", IF(AND([RPM %]851 > 0.01, [RPM %]851 < 0.49), "Quarter", IF(AND([RPM %]851 > 0.49, [RPM %]851 < 0.75), "Half", IF(AND([RPM %]851 > 0.74, [RPM %]851 < 0.99), "Three Quarter", IF([RPM %]851 >= 1, "Full", "")))))
In the screenshot that I've attached you'll see the 2nd row does not have the progress bar. There would be one if the RPM Progress column had the formula converted. But I noticed if I copy and paste the progress bar from the row, then the progress bar appears. See the 2nd screenshot.
Goal: I would like to have the formula activate on it's own instead of me copy/pasting. Is there another formula that I should be using? Any help would be greatly appreciated!
Best Answer
-
Hi @DEGUC010
Will this formula do?
=IF([RPM %]@row <= 0, "Empty", IF([RPM %]@row < 0.5, "Quarter", IF([RPM %]@row < 0.75, "Half", IF([RPM %]@row < 1, "Three Quarter", "Full"))))
Answers
-
Hi @DEGUC010
Will this formula do?
=IF([RPM %]@row <= 0, "Empty", IF([RPM %]@row < 0.5, "Quarter", IF([RPM %]@row < 0.75, "Half", IF([RPM %]@row < 1, "Three Quarter", "Full"))))
-
@jmyzk_cloudsmart_jp Yes, it worked!! You're AMAZING. ⭐️
Thank you so much!! 😆
-
Happy to help!😁
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.1K Get Help
- 450 Global Discussions
- 155 Industry Talk
- 505 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 80 Community Job Board
- 514 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- I hope my explanation makes sense. I currently have a basic formula that shows "networkdays" between 2 dates, however it obviously shows "invalid date type" when the "end date" has not been entered =N…
- I am struggling to get the formula right to solve this problem. My formula can count if there are duplicates in this field, but it also counts it if the field is blank (because many rows won't have a …
- Hi, I have a column that I'm trying to convert to column formula but won't because "The column formula syntax isn't quite right" and gives me Smartsheet's help article for more information. The column…