Forum Discussion

BuildPro's avatar
BuildPro
Qrew Captain
3 years ago

Formula assistance - days within range


How to do I make this work?


If([PROJ HANG NOTE]<>"","ALERT",
If(IsNull([ORIGINAL PROJECTED START DATE]),"PENDING",
If([ORIGINAL PROJECTED START DATE]<=TODAY() or within next 15 days, "STARTED?",

If([ORIGINAL PROJECTED START DATE] is within 16-20 days of today, "START NOW",
f([ORIGINAL PROJECTED START DATE] is within 21-30 days of today, "START SOON",

If([ORIGINAL PROJECTED START DATE] is after 31 days of today, ,"ON RADAR")))))

------------------------------
BuildPro
------------------------------
Formulas and functions
  • MikeTamoush's avatar
    MikeTamoush
    Qrew Commander
    3 years ago
    If(
    [PROJ HANG NOTE]<>"","ALERT",
    IsNull([ORIGINAL PROJECTED START DATE]),"PENDING",
    [ORIGINAL PROJECTED START DATE]<=TODAY() + Days(15), "STARTED?",
    [ORIGINAL PROJECTED START DATE] > TODAY() + Days(15) and [ORIGINAL PROJECTED START DATE] <= TODAY() + Days(20), "START NOW",
    [ORIGINAL PROJECTED START DATE] > TODAY() + Days(20) and [ORIGINAL PROJECTED START DATE] <= TODAY() + Days(30), "START SOON",
    [ORIGINAL PROJECTED START DATE] > TODAY() + Days(30) ,"ON RADAR"
    )

    Keep in mind it will evaluate from top to bottom, so as soon as it hits a true statement, it will put that status. Meaning, if there is something in Proj Hang Note, it will always say alert and never move on.

    Also, I went fast so just double check the greater than or greater than/equals to and days to be sure it is what you want.

    ------------------------------
    Mike Tamoush
    ------------------------------
    • BuildPro's avatar
      BuildPro
      Qrew Captain
      3 years ago
      Thank you...it works!

      ------------------------------
      BuildPro
      ------------------------------