Skip to main content
Question

Checkbox to Formula text field

  • February 12, 2020
  • 0 replies
  • 80 views
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
------------------------------
This topic has been closed for replies.

  • AustinK
  • Registered
  • February 12, 2020
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.
Terms & ConditionsAccessibility statement