Prerequisites
Before you begin make sure you have the following:
Plan: Standard
Permission: Org Controller or Project Controller or Team Controller
Skills Required: Dashpivot
Device Type: computer
Subscription: Dashpivot
Step-by-Step Instructions
Open the template you need to edit.
Identify the list (dropdown) cell you want to reference (for example, A1).
In the target calculation field, enter the following formula:
=IF(A1="YES",1,0)
Replace A1 with your actual cell reference.
Replace "YES" with the exact name of the dropdown list item you want to evaluate.
Save the template.
When the selected dropdown value matches the specified list item (for example, "YES"), the formula will return 1. If it does not match, the formula will return 0.
If your dropdown includes the options TRUE or FALSE, note that these are reserved words used for Boolean operations.
To use TRUE or FALSE as dropdown values, cast them as a string using the following formula format:
TEXT(CELL_REFERENCE,"0")
Replace CELL_REFERENCE with the appropriate cell reference.