Forum Discussion

Qrew Cadet

3 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

Icon for Qrew Legend rank

Qrew Legend

3 years ago

if([Percent Complete]=1, true)

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

AnnettaColeman
Qrew Cadet
3 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
  Qrew Cadet
  3 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
    Qrew Legend
    3 years ago
    ... no, it seems impossible.
    
    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------