Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

order in a formula ...

Solved
Jump to Solution
86 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

See Solution in Thread

2 Replies 2

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 ... 🙃