simple formula
Hey All, I've a formula Numeric Formula field that calculates Units Remaining. [Weekly Units]-[# Units Used] This works. Now I'm trying to create a message if this field goes NEGATIVE. i...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendtry this as a formula text field. I will use a formula variable to make the formula more tidy.
Also, btw, unlike excel you normally do not need to nest your IFs and you can avoid going cross eyed tryin to match up the lining up the parentheses.
var number UnitsRemaining = . [Weekly Units]-[# Units Used];
IF(
$UnitsRemaining < 0, "TOO MANY UNITS USED, TRY AGAIN",
$UnitsRemaining = 0, "zero",
ToText($UnitsRemaining))
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Also, btw, unlike excel you normally do not need to nest your IFs and you can avoid going cross eyed tryin to match up the lining up the parentheses.
var number UnitsRemaining = . [Weekly Units]-[# Units Used];
IF(
$UnitsRemaining < 0, "TOO MANY UNITS USED, TRY AGAIN",
$UnitsRemaining = 0, "zero",
ToText($UnitsRemaining))
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------