Connect with experts and redefine what’s possible at work – join us at the Microsoft 365 Community Conference May 6-8. Learn more >
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
