Skip to main content
Question

Change Formula When Checkbox Is Checked

  • September 28, 2017
  • 0 replies
  • 59 views
I currently have the most simple formula: [Addon]+[New]-[Removal]

What I would like, is: IF [Checkbox1] = checked, AND [Install] = Self, then output formula: [Addon]+[New]-[Removal]+[Replace]

But when the checkbox gets unchecked, output the first formula: [Addon]+[New]-[Removal]
      This topic has been closed for replies.

      • anomDiebolt
      • Quickbase Alumni
      • September 28, 2017
      Try this:

      If([Checkbox1] and [Install] = "Self",
        [Addon] + [New] - [Removal] + [Replace],
        [Addon] + [New] - [Removal]
      )
      • GeneStrelkov
      • Author
      • Quickbase Alumni
      • September 29, 2017
      I need to modify the first portion of the formula, to be: IF [Checkbox1] = checked, AND [Install] = Self, AND its more than 30 days from [DateField]
      Terms & ConditionsAccessibility statement