column

Copper Contributor

How do I make one column for example column A take its information {date}  from one column for example column B and if column B is empty it should take from column C?

1 Reply

@JW1234 You may try FILTER() function.

=@FILTER(B2:D2,B2:D2<>"","")

Harun24HR_0-1694142654729.png