How to Create Tend Arrows with a Function

I have a cross sheet table with data displayed on it that works fine. Just wondering how I can display a trend arrow using a function for Up, Down and Across.

Basically, I am measuring KPI performance against the number of days since the last time we had for example a Lost Time Injury or as is known as an LTI. This work fine with Paul's help. I now have a column which calculates what the number of days were the day before, so I can determine if its the Same, More, or Less.

In the next Column I want to display the Trend as a arrow.

This data is presented on a dashboard so that managers know their performance in regards to Health and Safety?

Table looks like this

[Type of Event], [Days Since Last Event], [Day Before], [Arrow]

The Italic Columns are extracted via cross sheet reference.

Regards

Steve

Find more posts tagged with

Formulas

Reports

Comments

Marcin P

Hi Steve,

Each arrow has its on value like "Up", "Sideways", etc. So all you need to do is to create nested IF formula and place it within column set to Symbols.

You can easily check what values they has by placing different arrows in column and enter =value(cell with arrow). Then you'll be able to create your formulas.

Andrée Starå

Hi Steve,

=IF([Days Since Last Event]@row = [Day Before]@row; "Sideways"; IF([Days Since Last Event]@row > [Day Before]@row; "Up"; "Down"))

The same version but with the below changes for your and others convenience.

=IF([Days Since Last Event]@row = [Day Before]@row, "Sideways", IF([Days Since Last Event]@row > [Day Before]@row, "Up", "Down"))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

I hope this helps you!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Steve Moss

Thanks Andree,

Works Perfectly.

Maybe you need to put the comment in that after you have put the function in you change the column to the Symbols and select the arrows you want to use.

Kind Regards

Steve Moss

Thanks,

Marcin,

Andree sorted it perfectly for me.

Kind Regards

Steve

Andrée Starå

Great!

Happy to help!

Great suggestion regarding the type of symbols and it's important to choose the correct one because otherwise, the formula needs to be updated to reflect the values for other symbols.

Sign in to join the conversation!

Quick Links

Trending discussions

Is there a way to create a 3-digit padding for numbers
Hi all, and thanks in advance! I wanted to know if there was any way to create "padding" in Smartsheet. Basically I have account numbers, and a handful are still 2-digit, so they appear as TDL-17, TDL-67, etc. Most of the accounts are 3-digit numbers like TDL-180. I want something that will recognize whether it is 2 or 3…
Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?