IF statement and default value not working?

Platform discussions
1

Hi,

I managed to create an if formula for Voting calculation, but for some reason the default value “None” for the Formula column (e.g. before any voting happens) does not work (or actually nothing happens). Could someone help me out here :face_with_peeking_eye:

Here’s the code:

IF(AND({Critical#Count} >= {High#Count}, {Critical#Count} >= {Medium#Count}, {Critical#Count} >= {Low#Count}), 
   "Critical", 
   IF(AND({High#Count} > {Critical#Count}, {High#Count} >= {Medium#Count}, {High#Count} >= {Low#Count}),
      "High", 
      IF(AND({Medium#Count} > {Critical#Count}, {Medium#Count} > {High#Count}, {Medium#Count} >= {Low#Count}),
         "Medium", 
         IF(AND({Low#Count} > {Critical#Count}, {Low#Count} > {High#Count}, {Low#Count} > {Medium#Count}),
            "Low", 
            "None"
         )
      )
   )
)