Forum Discussion
Solved
** HELP ** NEED PREPOPULATED MESSAGE TO APPEAR BASED ON VARYING DATA
Hi HansVogelaar,
I require your assistance once more. 
what im aiming to do is the following:
If CELL E9 = "2b - Migrated" (Blue Circle)- I want the following message to appear as in the red circle.
If CELL E9 = "Planned 2a Migration" then I want it to say "PLEASE NOTE THERE IS A PLANNED MIGRATION ON (VALUE IN CELL E8) WHICH IS (VALUE OF CEL AH8) BUSINESS DAY FROM TIME OF EMAIL **
If CELL E9 - "Planned 2b Migration" then I want it to say "PLEASE NOTE THERE IS A PLANNED MIGRATION ON (VALUE IN CELL E8) WHICH IS (VALUE OF CEL AH8) BUSINESS DAY FROM TIME OF EMAIL AND THIS WILL NEED TO GO VIA DNE **
=IFS(E9="2b - Migrated", "x", E9="Planned 2a Migration", "PLEASE NOTE THERE IS A PLANNED MIGRATION ON "&TEXT(E8, "dd/mm/yyyy")&" WHICH IS "&AH8&" BUSINESS DAY(S) FROM TIME OF EMAIL **", E9="Planned 2b Migration", "PLEASE NOTE THERE IS A PLANNED MIGRATION ON "&TEXT(E8, "dd/mm/yyyy")&" WHICH IS "&AH8&" BUSINESS DAY(S) FROM TIME OF EMAIL AND THIS WILL NEED TO GO VIA DNE **", TRUE, "")
=IFS(E9="2b - Migrated", "x", E9="Planned 2a Migration", "PLEASE NOTE THERE IS A PLANNED MIGRATION ON "&TEXT(E8, "dd/mm/yyyy")&" WHICH IS "&AH8&" BUSINESS DAY(S) FROM TIME OF EMAIL **", E9="Planned 2b Migration", "PLEASE NOTE THERE IS A PLANNED MIGRATION ON "&TEXT(E8, "dd/mm/yyyy")&" WHICH IS "&AH8&" BUSINESS DAY(S) FROM TIME OF EMAIL AND THIS WILL NEED TO GO VIA DNE **", TRUE, "")
