Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
7 years ago

Need to create a formula that checks 2 parameters

I need a formula that says
When [Escalation] = 4HR and [2 HR Notification] is checked, check [4 HR Notification]
Thank you.
App builders
Formulas and functions
    • _anomDiebolt_'s avatar
      _anomDiebolt_
      Qrew Elite
      7 years ago
      shorter:

      [Escalation] = "4HR" and [2 HR Notification]

      But to be honest I think the OP needs a form rule because I don't think  [4 HR Notification] is a formula field.
    • ArchiveUser's avatar
      ArchiveUser
      Qrew Captain
      7 years ago
      I'm not very good with formulas. What I have now is

      If(Contains([Escalation], "4HR"), true)
      How do I change this?
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      7 years ago
      I suggest that you try my formula above. It turns out in Quickbase you don�t actually need to make an
      IF statement when the result is going to be true or false. You can just make a statement and if the statement evaluates to true then the checkbox will get checked.

      I am in the car right now so it�s a little hard to type but if I get a chance I will write out a longer formula that will make more sense to you. But meanwhile why don�t you just try a new field with my formula and see if it works.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    I spoke to Stephanie on a GTM and her situation was quite a bit more complex than was outlined in her post, though it was vaguely alluded to in the headline.  She in fact has multiple records for the same Ticket# and data from those multiple records needed to be combined into a formula text result.

    I showed Stephanie how to make a table of unique Ticket numbers and maintain it by importing a summary report into that table after each data import of a fresh batch of tickets.   Then we did some summary fields and a formula to combine the result of the tickets with the same Unique ticket #.