Forum Discussion

sruk89's avatar
sruk89
Brass Contributor
Nov 02, 2023
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...
excel
Formulas and Functions
Macros and VBA
  • HansVogelaar's avatar
    HansVogelaar
    Nov 02, 2023

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

HansVogelaar's avatar
HansVogelaar
MVP
Nov 02, 2023

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