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] Bu...
_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
    Looks perfect. Thank you!!