How to use Trend Arrows to show change in RYG

edited 12/09/19 in Smartsheet Basics

Is there a formula that would highlight the trend of a change in RYG balls ?

For example, if someone changes the status of a project from Green to Red, it would show a down arrow. If someone changes the arrow from Red to Yellow, it would show a Upward arrow.

Thanks for your help!