# Text Formula Field returning Blank

I have used formulas in this program for a while now and have had no issue until recently.

The field this formula is stored in is a text-formula type.

Formula:

If(

//Checkmark Boxes

[Billed]=true,"Billed",

[Invoice Drafted]=true,"Invoice Drafted",

[Approved]=true,"Approved",

[Hold for Authorization]=true,"Hold for Authorization",

//Reading Billing Status

Begins([Billing Status (Billing Team ONLY)],"Billed"),"Billed",

Begins([Billing Status (Billing Team ONLY)],"Invoice Drafted"),"Invoice Drafted",

//Formula

Contains([Service Billing Adds (Memo required)],"**NOT BILLABLE (Leave Comment)**"),"NOT BILLABLE",

[Project - Total Task Remaining Hours]>0 and [Project - Total Task Remaining Hours]<1.5 and [Project Type]<>"Advisory","Hold for More Time",

[Billing Family - Total Over Set Days (Connection)]>0,"Approved",

[Billing Family Approved Total]>500 and [Billing Family Approved Total]<1000,"Approved",

[Billing Family Approved Total]>1000,"Hold for Authorization",

"No Rule for This")

Now to my understanding, if I have, "No Rule for This", at the end of this formula,

then anything that doesn't fall into the above formula should just read, "No Rule for This".

When I use the new formula checker that is in beta, it confirms this theory.

However, I have some cells that are returning nothing (see image), they are blank.

------------------------------

Paul Huizenga

------------------------------