Skip to main content
Question

Adding a total to a rich text formula

  • March 11, 2019
  • 0 replies
  • 41 views
Hello, I have a Rich Text Formula field that takes numeric data from another field and turns negative #'s red and positive #'s green. Is it possible to total this formula field?
      This topic has been closed for replies.

      • BridgetHesselin
      • Author
      • Quickbase Alumni
      • March 11, 2019
      I was afraid of that. Thanks for your help!
      Forum|alt.badge.img+3
      No.
      Would it be possible instead to total the numeric field that you've already got? You can't sum a text formula field because it's not a number, but it sounds like you already have the number itself stored somewhere else.
      • BridgetHesselin
      • Author
      • Quickbase Alumni
      • March 11, 2019
      Thanks Alex! I do have the numeric field totaled, but was hoping to have this all displayed in a single column on reports. 
      .. it sure would be nice to just have cell level conditional formatting like excel does.  Then we would not have to do these Rich Text formuals which are especially difficult with numbers with decimals, such as currency and we would still get our easy totals.
      Terms & ConditionsAccessibility statement