Hi All,
I have a calc field called [TOTAL] that adds up a bunch of sub fields. Formula is:
sum(Labor - 3rd Party) + Labor + Supernumerary + Labor - Project Mgr. + Materials + Freight + Travel + License Costs + Hardware + Software + Other + Contingency
I am trying to add conditional formatting, or validation, so that if TOTAL is not at least 50K, the user is notified. But I cannot seem to do this on a calculated field. Can anyone help?