Change Formula When Checkbox Is Checked

  • 1
  • 1
  • Question
  • Updated 1 year ago
  • Answered
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]
Photo of Gene

Gene

  • 94 Points 75 badge 2x thumb

Posted 1 year ago

  • 1
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,572 Points 20k badge 2x thumb
Try this:

If([Checkbox1] and [Install] = "Self",
  [Addon] + [New] - [Removal] + [Replace],
  [Addon] + [New] - [Removal]
)
Photo of Gene

Gene

  • 94 Points 75 badge 2x thumb
Looks perfect. Thank you!!
Photo of Gene

Gene

  • 94 Points 75 badge 2x thumb
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]