JW1234Copper ContributorSep 08, 2023columnHow 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?
Harun24HRBronze ContributorSep 08, 2023JW1234 You may try FILTER() function.=@FILTER(B2:D2,B2:D2<>"","") date_from_next_column.xlsx11 KB
Harun24HRBronze ContributorSep 08, 2023JW1234 You may try FILTER() function.=@FILTER(B2:D2,B2:D2<>"","") date_from_next_column.xlsx11 KB
