IF isBlank on multiple columns return first nonblank date.

[PeteyG]

Hello all-

I am trying to create a new column called in this example "Issued Date"  What I need it to do is look back at Date4 and if it has a date put that date in.  If blank look at date3.  If it has a date return that one otherwise going to Date2 and so on.  I can do it between two columns but as soon as I add a third and forth I get two many arguments errors.  Anyone have a work around?

Item	Date1	Date2	Date3	Date4	Issued Date
item1	9/29/2021	12/21/2022	9/12/2023		9/12/2023
item2	9/29/2021	12/21/2022	9/12/2023	5/29/2024	5/29/2024
item3	9/29/2021				9/29/2021
item4	9/29/2021	12/21/2022	9/12/2023	5/29/2024	5/29/2024
item5	9/29/202	12/21/2022			12/21/2022
item6	9/29/2021				9/29/2021
item7	9/29/2021	12/21/2022	9/12/2023		9/12/2023
item8	9/29/2021	12/21/2022	9/12/2023	5/29/2024	5/29/2024

[parry2k]

@PeteyG Happy to help. Cheers!

[parry2k · Accepted solution]

@PeteyG you can try something like this:

Issued Date = 
COALESCE ( Table[Date4], Table[Date3], Table[Date2], Table[Date1] )

[PeteyG]

That was perfect!  I can not believe how much time I spent on nested if statments to not work.  Thanks so much!