Skip to main content
Question

Duration Formula with If Statement and Checkbox

  • May 15, 2017
  • 0 replies
  • 55 views
I have a duration field that I only want to calculate if a checkbox is checked. I have the following formula but it's still calculating a duration even if the condition isn't met:

If(ToText([NTO Resolved in Field])="Yes",Days(0),[Contractor Resolved Date]-[Creation Date])

Can someone help me figure out what I'm doing wrong? 
      This topic has been closed for replies.

      • MCFNeil
      • Registered
      • May 15, 2017
      Is your checkbox field [NTO Resolved in Field]?

      If so, try this:

      If([NTO Resolved in Field]=false, null, [Contractor Resolved Date]-[Creation Date])

      ...
      • DanaDana
      • Author
      • Registered
      • May 15, 2017
      This did the trick, thank you so so much!
      • DavidHawe
      • Registered
      • May 15, 2017
      For future reference, use TRUE or FALSE without quotes when testing the value of a checkbox
      Terms & ConditionsAccessibility statement