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