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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!