Need two if conditions for a numeric formula
I'm trying to make a numeric formula field that will only calculate a Total Invoice if the Override Points are blank (or zero) AND the Approved checkbox is checked (true). This part works If([Proj...
Forum Discussion
Try this:
If([Project Points Override] = 0 and [Approved] = true,
[Project Points]*[Contract Coach - Current Rate], [Project Points Override]*[Contract Coach - Current Rate])
------------------------------
Ahuva Brown
------------------------------
If([Project Points Override] = 0 and [Approved] = true,
[Project Points]*[Contract Coach - Current Rate], [Project Points Override]*[Contract Coach - Current Rate])
------------------------------
Ahuva Brown
------------------------------