Forum Discussion

domden's avatar
domden
New Member
4 years ago
Solved

change date to custom text

Hello everybody, I hope you can help me.

I think my problem is simple to solve, but I just dont get it...

What I have:

Topicdone at
A27.04.2022
B26.04.2022
Cnull(emtpy/blank)
D25.04.2022
E

null(empty/blank)

 

What i want:

Topicdone at
Adone
Bdone
Copen
Ddone
E

open

 

So when there is a date in the field, I want to have a custom Text, like "done".

When the cell is null/empty, I want another text, like "open".

 

I hope you guys can help me.

 

1 Reply