Help

Re: order in a formula ...

Solved
Jump to Solution
1752 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Gregool
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi,

In one column I want to get shown a trend more obvious with colours.

So I want the difference to the week before and in this case a green or a red broken heart.

But somehow I am not allowed to put the heart at the front and the difference at the end ...
(se result: NaN) 🤔

Any idea, what I cannot see right now?

Best regards,
Martin

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

Hm, instead of using `&`, try using `CONCATENATE()`?  That should solve it I think

See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

Hm, instead of using `&`, try using `CONCATENATE()`?  That should solve it I think

Thank you.
But somehow I saw that my old way finally got accepted, too ... 😕🤔
I cannot say, that I changed anything since then, but I tell you:
While a Mercury Retrograde strange things got happen in all stuff of communication ... 🙃