Hey folks --
I'm wondering if there are things I should be considering when choosing between a checkbox and picklist to capture Yes/No responses.
The big reason I'm considering a picklist is because I can create a validation rule that requires a response one way or the other. It currently a checkbox that people are often skipping altogether.
Would love your thoughts!
#Salesforce Admin #Saleforce Administrator #Validation Rule
They both have their pros and cons, depending on what you're trying to do
As you pointed out a Checkbox field can't be blank, or empty, it can only be True or False, which can skew results
Picklist fields have the "advantage" of a 3rd option (blank/empty) in addition to a Yes/No response.
Checkbox values are stored as a 1 = True/Checked or 0 = False/Unchecked, which makes them a LOT easier to Count or do Math with in Report Formulas.
Picklist Values can be counted, but it's a lot trickier, and you're limited to 1 Row-Level Formula per Report