Creating a function formula to insert arrow indicators
Hi,
I have one column called "Revenue is declining, stable, or growing" with numeric values of 1,2,3
The numeric values go into a total score and ranking for the account. That works fine.
In addition, in a separate column, I need to set up a function to give an up, down, neutral indicator based off the value in the above column.
Here's what I've tried and get an unparseable error:
=IF([Revenue is declining, stable, or growing]@row = 2, "Sideways", IF([Revenue is declining, stable, or growing]@row = 3 "Up",IF([Revenue is declining, stable, or growing]@row = 1, "Down"))
Here's an example of what I'm aiming for but I don't have the function set correctly for the trend indicator.
Thanks!
Best Answers
-
If you mean like this:
=IF([Revenue is declining, stable, or growing]@row = 2, "Sideways", IF([Revenue is declining, stable, or growing]@row = 3 "Up", IF([Revenue is declining, stable, or growing]@row = 1, "Down")))
I still get an unparseable error. (Revenue Trend was set up as symbols after I saved the formula).
I'm missing something...?
Thanks
-
I was missing a comma after the 3. Solved with persistence!
Thanks
Answers
-
Your formula is missing the third closing “)” on the end. Also, make sure the [Revenue Trend] column is setup as Symbols.
-
If you mean like this:
=IF([Revenue is declining, stable, or growing]@row = 2, "Sideways", IF([Revenue is declining, stable, or growing]@row = 3 "Up", IF([Revenue is declining, stable, or growing]@row = 1, "Down")))
I still get an unparseable error. (Revenue Trend was set up as symbols after I saved the formula).
I'm missing something...?
Thanks
-
I was missing a comma after the 3. Solved with persistence!
Thanks
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!