Forum Discussion

GeneStrelkov's avatar
GeneStrelkov
Qrew Cadet
8 years ago

Change Formula When Checkbox Is Checked

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]
  • _anomDiebolt_'s avatar
    _anomDiebolt_
    Qrew Elite
    8 years ago
    Try this:

    If([Checkbox1] and [Install] = "Self",
      [Addon] + [New] - [Removal] + [Replace],
      [Addon] + [New] - [Removal]
    )
  • GeneStrelkov's avatar
    GeneStrelkov
    Qrew Cadet
    8 years ago
    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]