How to perform trend analysis on symbols
I have a sheet where I have two columns that show status (current and previous). These are represented by the colored dots (Red, Yellow, Green, Gray). I am trying to show tend on these status items with the following logic:
=IF([Trend - Last Report status]1 = [Overall Status]1, "Sideways", IF([Trend - Last Report status]1 < [Overall Status]1 "Up", "Down"), "")
Is this possible when using symbols or will I need to build IF logic to perform text matching i.e.
=IF([Trend - Last Report status]1 = [Overall Status]1, "Sideways", IF([Trend - Last Report status]1 = "Red", IF( [Overall Status]1 = "Yellow", "Up", ....... and so on.
Any help would be appreciated.
Best Answers
-
Hi @Ed Sheaf
You will need to build the IF logic formula because Smartsheet doesn't know what it should consider is more or less for Symbols.
Make sense?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
Hi @Ed Sheaf
You will need to build the IF logic formula because Smartsheet doesn't know what it should consider is more or less for Symbols.
Make sense?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi Andree,
I suspected this would be the case. I decided to build a grid sheet that determined hierarchy of symbols in relation to their row position.
=INDEX([Symbol Measurement]7:[Symbol Measurement]10, MATCH(Symbol20, Symbol$7:Symbol$10, 0)) - INDEX([Symbol Measurement]7:[Symbol Measurement]10, MATCH(Symbol21, Symbol$7:Symbol$10, 0))
And then checked to see if value had gone up or down.
Thanks for you help.
Cheers,
Ed
-
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
Check out the Formula Handbook template!
