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
David Huang 34David Huang 34 

formula for multi-slect field

Hi there,

how to write this formula
I have a multi-select field
the formula is: once option is selected, no matter how many are selected, return 1, if no options are selected, return 0


David
Best Answer chosen by David Huang 34
CharuDuttCharuDutt
Hii David
Try Below Formula Data Type Number 
IF(NOT(ISBLANK(multiselectpicklist Field Name)),1,0)
Please Mark It As Best Asnwer If It Helps
Thank You!

All Answers

CharuDuttCharuDutt
Hii David
Try Below Formula Data Type Number 
IF(NOT(ISBLANK(multiselectpicklist Field Name)),1,0)
Please Mark It As Best Asnwer If It Helps
Thank You!
This was selected as the best answer
David Huang 34David Huang 34
thanks CharuDutt, you are a wizard