Skip to main content
Question

Formula assistance - days within range

  • December 9, 2021
  • 0 replies
  • 23 views
Forum|alt.badge.img+11

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

Forum|alt.badge.img+20
  • MikeTamoush
  • Registered
  • December 9, 2021
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
------------------------------
Terms & ConditionsAccessibility statement