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
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__You
Qrew Legend
Qrew LegendI 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
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------