function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Naveen Velkur 6Naveen Velkur 6 

checkbox formula help :

what is the formula to display only checked boxes, i have  check box fields Red,Green,Orange,Yellow, Violet  in the form, User have checked Red, Green and Orange leaving others unchecked. What is the formula to display checked boxes in the Merge Fields?
Arun Kumar 1141Arun Kumar 1141
If you want to display only selected check box fields, you can use the formula given below.
  
=IF(Red, "Red ", "") & IF(Green, "Green ", "") & IF(Orange, "Orange ", "") & IF(Yellow, "Yellow ", "") & IF(Violet, "Violet ", "")

If you find this helpful, please mark it as best answer.

Thanks.