Forum Discussion

AnnettaColeman's avatar
AnnettaColeman
Qrew Cadet
4 years ago

Percent Complete does not trigger boolean Formula Field

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 "A...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
if([Percent Complete]=1, true)

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
  • AnnettaColeman's avatar
    AnnettaColeman
    Qrew Cadet
    4 years ago
    Yes, I tried both 1 and 100.   Neither worked.  Didn't get error, just didn't work.   Leaving it alone for now because I have higher priority functionality to get working.

    ------------------------------
    Annetta Coleman
    ------------------------------
    • AnnettaColeman's avatar
      AnnettaColeman
      Qrew Cadet
      4 years ago
      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's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        4 years ago
        ... no, it seems impossible.

        ------------------------------
        Mark Shnier (YQC)
        mark.shnier@gmail.com
        ------------------------------