If statement formula problem
Hi QuickBase Community,
I am struggling with a Formula-Duration field in which I'm trying to calculate the number of days since a customer agreement was signed using an if statement conditioned...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendYour formula looks correct, so there must be unexpected data in the record.
Is the Status on a test record actually "Complete" or perhaps is it "Completed". What exactly is in the [Customer Type] field on a test record that is misbehaving.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Is the Status on a test record actually "Complete" or perhaps is it "Completed". What exactly is in the [Customer Type] field on a test record that is misbehaving.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Mark, thank you for verifying my formula syntax was correct. Since I'm relatively new to formulas I was convinced it was something more complex. You also identified the root cause of the problem. I was searching for Complete when the field value is Completed! "Is there a 'd,' Pat?" I was able to solve the puzzle. :-)
------------------------------
Doug Crandall
------------------------------
------------------------------
Doug Crandall
------------------------------
- MarkShnier__YouI might have seemed to be clairvoyant to be able to see into your data, but it's really just that I have tripped over that same error too many times myself.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------