Discussions

 View Only
  • 1.  Change Formula When Checkbox Is Checked

    Posted 09-28-2017 13:06
    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]


  • 2.  RE: Change Formula When Checkbox Is Checked

    Posted 09-28-2017 13:11
    Try this:

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


  • 3.  RE: Change Formula When Checkbox Is Checked

    Posted 09-28-2017 13:23
    Looks perfect. Thank you!!


  • 4.  RE: Change Formula When Checkbox Is Checked

    Posted 09-29-2017 14:20
    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]