How to perform trend analysis on symbols

Ed Sheaf

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.

Andrée Starå

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!

Andrée Starå

@Ed Sheaf

Excellent!

You're more than welcome!

Andrée Starå

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!

Ed Sheaf

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

Andrée Starå

@Ed Sheaf

Excellent!

You're more than welcome!