Skip to main content
Question

Simple formula help

  • April 23, 2020
  • 0 replies
  • 50 views
Hi,

I am trying to write a formula to color code my report. Basically what needs to happen is that the row is highlighted if the field [total cost] does not equal the field [total line item amount] (this is a summary field).

I attempted to write a formula but it's highlighting the wrong rows. I do not have any coding experience so I'm struggling.

THANK YOU!!

#formula ​​

------------------------------
Sophie A Primeaux
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • MarkShnierYou
  • Quickbase Alumni
  • April 23, 2020
np,
Try this as a row colorization formula on on a  table report type.

IF([total cost] <> [total line item amount], "pink")

or the word yellow works works nicely too for a color.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement