Skip to main content
Question

is not null problem

  • Nov 6, 2021 2:10 AM UTC
  • 0 replies
  • 21 views
Forum|alt.badge.img+11
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
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+11
  • BuildPro
  • Author
  • Qrew Corporal
  • Nov 6, 2021 2:31 AM UTC
I think I fixed it...

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

------------------------------
BuildPro
------------------------------
Terms & ConditionsAccessibility statement