Percent Complete does not trigger boolean Formula Field

Question

In a project activity table I am trying to save users a few click strokes.&nbsp; &nbsp;When the numeric percentage field "Percent Complete" =100 I would like to automatically mark the formula checkbox field "Activity Complete" to True.&nbsp; &nbsp;Doesn't work for ANY value.&nbsp; &nbsp; 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.&nbsp; &nbsp;Doesn't work with ANY value.&nbsp; &nbsp;Tried 100,&nbsp; tried 1.&nbsp; &nbsp;Tried a few decimal combinations.&nbsp; &nbsp;Nothing will turn these boolean formula fields to True / Yes.&nbsp; &nbsp;
What is the trick to get a numerical percentage field to properly trigger a formula?&nbsp; &nbsp; &nbsp;&nbsp;------------------------------Annetta Coleman------------------------------

markshnier__you · Answer

if([Percent Complete]=1, true)------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

annettacoleman · Answer

Yes, I tried both 1 and 100.&nbsp; &nbsp;Neither worked.&nbsp; Didn't get error, just didn't work.&nbsp; &nbsp;Leaving it alone for now because I have higher priority functionality to get working.------------------------------Annetta Coleman------------------------------

annettacoleman · Answer

As weird as this sounds, after a reboot of my laptop, the percent complete boolean formula fields worked without a hitch. This does not make sense to me. Can you shed any light on this?

------------------------------
Annetta Coleman
------------------------------

markshnier__you · Answer

... no, it seems impossible.------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

Forum Discussion

Percent Complete does not trigger boolean Formula Field