If Statement on Rich Text - Formula
Hey Everyone, I'm running into an issue, I'm attempting to total up some durations that are being calculated across multiple fields (7), that way I can figure out overall duration for a job. I keep...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendCan you post your latest attempt?
------------------------------
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
------------------------------
(ToText(Ceil([6. Sub Duration]/8) & " " & "Days"))
So this is the code to take the final number and display it in days. If I try to add an If statement to that to say if that result is blank, then display 0 I get errors
------------------------------
Alex Bennett
------------------------------
So this is the code to take the final number and display it in days. If I try to add an If statement to that to say if that result is blank, then display 0 I get errors
------------------------------
Alex Bennett
------------------------------
- MarkShnier__YouWhat does this formula now display when [6. Sub Duration] is blank? I suppose that it just says "Days".
try this
var text Result = (ToText(Ceil([6. Sub Duration]/8) & " " & "Days"));
IF(Trim($Result)="", "0 Days", $Result)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- So some sections just say "Days" and others are left blank with nothing. Even If I add that code.
------------------------------
Alex Bennett
------------------------------- MarkShnier__YouCan you try this version
var text Result = ToText(Nz(Ceil([6. Sub Duration]) / 8;
IF(Trim($Result)="", "0", $Result) & " " & "Days"));
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------