is not null problem

Question

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 fieldProjected Start Date is a date fieldPlease help...thx------------------------------BuildPro------------------------------

BuildPro · Answer

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

Sign up

Login to the community