IF Statement Error

[jhoyabel19]

HI, 

Im trying to create a separate column to complete all the dates to a have a final dates without blank

• Offer accepted column is blank get the date from
• Offer Accepted Onboarding but if this is blank
• get the dates from Accepted forms reviewed but if this is blank
• get the dates from Forms completed but if this is blank
• get the dates Accepted Forms completed Pending Review

I want the outcome like the Final Dates

offer Accepted	Offer Accepted (On Boarding)	Accepted forms reviewed	Forms completed	Accepted Forms completed Pending Review	Final Dates
07/02/2022					07/02/2022
18/02/2022					18/02/2022
23/02/2022					23/02/2022
23/02/2022					23/02/2022
Blank	11/03/2022				11/03/2022
Blank	11/03/2022				11/03/2022
Blank	11/03/2022				11/03/2022
Blank	Blank	11/05/2022			11/05/2022
Blank	Blank	11/05/2022			11/05/2022
Blank	Blank	11/05/2022			11/05/2022
Blank	Blank	Blank	24/02/2022		24/02/2022
Blank	Blank	Blank	Blank	05/04/2022	05/04/2022

[Mikelytics]

Hi @jhoyabel19 

Can you please share some sample data and show the expected outcome?

Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.

[jhoyabel19]

Data is similar like this, sorry tried posting as table but cant idk why

[Mikelytics]

Hi @jhoyabel19 

Thank you but together with you descripition it is a little bit confusing to be hoenst.

Please provide.

- Input

- Business rules

- expected output incl. how visual should look like

Best regards

Michael

[jhoyabel19]

@Mikelytics Sorry here's a better sample, i want the outcome as the Final Dates Column

Offer Accepted	Offer Accepted (On Boarding)	Accepted forms reviewed	Forms completed	Accepted Forms completed Pending Review	Final Dates
07/02/2022					07/02/2022
18/02/2022					18/02/2022
23/02/2022					23/02/2022
23/02/2022					23/02/2022
Blank	11/03/2022				11/03/2022
Blank	11/03/2022				11/03/2022
Blank	11/03/2022				11/03/2022
Blank	Blank	11/05/2022			11/05/2022
Blank	Blank	11/05/2022			11/05/2022
Blank	Blank	11/05/2022			11/05/2022
Blank	Blank	Blank	24/02/2022		24/02/2022
Blank	Blank	Blank	Blank	05/04/2022	05/04/2022