Forum Discussion
PeteyG
Helper I
2 years agoIF isBlank on multiple columns return first nonblank date.
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 |
PeteyG you can try something like this:
Issued Date = COALESCE ( Table[Date4], Table[Date3], Table[Date2], Table[Date1] )
3 Replies
- PeteyG
Helper I
That was perfect! I can not believe how much time I spent on nested if statments to not work. Thanks so much!