Forum Discussion

BuildPro's avatar
BuildPro
Qrew Captain
4 years ago

is not null problem

There are extra characters beyond the end of the formula.


If(IsNull([ESTIMATED START DATE]),"Pending","Start Folder")  ,
(notisNull([Job - Projected Start Date]),"Started")

Estimated Start Date is a text field
Projected Start Date is a date field

Please help...thx


------------------------------
BuildPro
------------------------------
Formulas and functions
  • BuildPro's avatar
    BuildPro
    Qrew Captain
    4 years ago
    I think I fixed it...

    If(
    [Job - Projected Start Date]>=Date(2021,7,10),"Started",
    If(IsNull([ESTIMATED START DATE]),"Pending","Start Folder"))

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