In a project activity table I am trying to save users a few click strokes. When the numeric percentage field "Percent Complete" =100 I would like to automatically mark the formula checkbox field "Activity Complete" to True. Doesn't work for ANY value. It was bugging me, so I set up an additional temporary formula Text field ''Activity Complete (text)" to automatically display "yes" if the Percent Complete field =100. Doesn't work with ANY value. Tried 100, tried 1. Tried a few decimal combinations. Nothing will turn these boolean formula fields to True / Yes.
What is the trick to get a numerical percentage field to properly trigger a formula?
------------------------------
Annetta Coleman
------------------------------
