Skip to main content
All CollectionsSupport GuideDashpivot - WebFormulas Functions
How to populate a number based on a dropdown selection
How to populate a number based on a dropdown selection
Erin Clazie avatar
Written by Erin Clazie
Updated over 5 months ago

Populating a number based on dropdown selection

Where A1 is a list cell, and "YES" is a list item name in the dropdown. This will populate 1 if Yes is selected, otherwise a 0 will be populated.

=IF(A1="YES",1,0)

Please note that the dropdown options TRUE and FALSE are reserved words used for our supported Boolean operations. To correctly use TRUE and FALSE options in the list dropdown, you will need to cast them as a string using the formula: TEXT(CELL_REFERENCE, "0")
​

Did this answer your question?