Forum Discussion

JoshuaSmith's avatar
JoshuaSmith
Qrew Trainee
5 years ago

Checkbox to Formula text field

I have 8 checkbox fields that we use to send customers emails.
Each checkboxfield sends a different email. Excellent it works like a charm. But on my reports I dont want to have to add all 8 fields to see which email was sent. I would like 1 rich text formula field that I could see which checkbox was clicked on.

Something like
if([1)Trying to to make first contact] = checked, then this text would show up"made first contact" 
But I am not seeing  a formula to turn checkbox results into text.

Thanks for you guys help I know its probably simple but not seeing it.

------------------------------
Joshua Joshua
------------------------------
Formulas and functions

2 Replies

Sort By
  • AustinK's avatar
    AustinK
    Qrew Commander
    5 years ago
    So there will not be a time where more than 1 checkbox is checked? This will stop once it hits the first thing that is true and display that. This is for a formula - text.

    If([first contact] = true, "Made first contact",
    [second contact] = true, "Made second contact",
    [third contact] = true, "Made third contact",
    [fourth contact] = true, "Made fourth contact",
    )
     Etc. Although you might be better off with a multiple choice text or something like that instead of a bunch of checkboxes. But if the checkboxes work they work.
    • JoshuaSmith's avatar
      JoshuaSmith
      Qrew Trainee
      5 years ago
      Thanks Austin

      Yeah tried a multiple choice text and the emails would fire all over the place. So the checkboxes work the best. thanks

      ------------------------------
      Joshua Joshua
      ------------------------------