** HELP ** NEED PREPOPULATED MESSAGE TO APPEAR BASED ON VARYING DATA

[sruk89]

Hi @Hans Vogelaar,

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 **

[#2 · Accepted solution]

@sruk89 

=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, "")