How can I?

Mel C

Hi

I am trying to create a automatic function whereby reviewing the status of two cells it will be able to show a progress status in the form of arrow symbols

for example if i have :

column 1 status total = 4

Column 2 updated weekly total =6

Column 3 movement progress = automatic appearance of ⬆️ ➡️ ⬇️ symbols.

I am struggling to create the right formula to do is, can anyone help?

thanks

mel

Paul Newcome

I would use this symbol column type:

The formula would be...

=IF([Column 2]@row = [Column 1]@row, "Unchanged", IF([Column 2]@row< [Column 1]@row, "Down", "Up"))

Paul Newcome

What would be the logic for up, right, and down arrows?

Mel C

Hi Paul

I want to Show progress up = forward progress/ Down = backwards progress/ sideways has remained the same.

there may be a better way of showing this so happy for any options really.

thanks

Mel

Paul Newcome

I would use this symbol column type:

The formula would be...

=IF([Column 2]@row = [Column 1]@row, "Unchanged", IF([Column 2]@row< [Column 1]@row, "Down", "Up"))

Mel C

Paul Thank you so much that worked a treat.

kind regards

Mel

Paul Newcome

Happy to help. 👍️