I want to assign a Yes or No to a column based on if another variable is Blank or not.
Would it be something like this?
if OpenedDate is Empty then
set Opened = No
if OpenedDate is NotEmpty then
set Opened = Yes
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.
Sign up to join this communityYou need to use a CASE statement in order to accomplish this. So something like:
CASE WHEN OpenedDate IS NULL THEN 'No' ELSE 'Yes' END AS 'Opened'